Sql Server 2005 business intellengence Report Wizard Date Picker dd/MM/yyyy

• sthenmozhi14

  Valued Member

  Points: 61

  More actions

  January 30, 2010 at 1:03 am

  #386209

  Hi All,

  I am using Sql Server 2005 business intellengence Report Wizard.

  I have two parameter fromdate and todate.In that date picker it show MM/dd/yyyy format.If i select 30 th jan in 2010.it show /1/30/2010.I want show 30/1/2009 in that date picker control.

  Can u help me....

  Thank you

  Regards

  Thenmozhi S

• Marco André Duarte Francisco

  SSC Veteran

  Points: 212

  More actions

  January 30, 2010 at 3:47 pm

  #1111252

  Nice question, never though that...;-)

  Have you tried to change report properties to your contry?

• sthenmozhi14

  Valued Member

  Points: 61

  More actions

  January 31, 2010 at 9:39 pm

  #1111409

  Hi Marco André Duarte Francisco,

  Thank you for your reply.

  I tried to change system datetime format (dd-MMM-yyyy).

  Its working.....

  Thank you

  Regards

  Thenmozhi S

• Marco André Duarte Francisco

  SSC Veteran

  Points: 212

  More actions

  February 1, 2010 at 2:15 am

  #1111466

  I wasn't aware to change data picker with format statement. How did you, btw?

  When you use a textbox and want to show data, yes you can format, but changing parameter datetime?

  Maybe I didn't realise your problem...