Post reply

Convert Date from mm/dd/yyyy to dd/mm/yyyy

  • June 26, 2006 at 4:31 pm

    #168984

    Hello

    can anyone help me, please?

    I just want to display the today’s date as dd/mm/yyyy for my report in RS

     

    I use VS2005.

    I just grab text box then in expression field I choose  (=today)

    But it appears with mm/dd/yyyy    How do I convert it?

     

    I can’t use CONVERT(varchar,today,103)

     

    When I go to the property, under format tab, I can’t find dd/mm/yyyy.

     

    Thanks,

    Susan

  • June 27, 2006 at 8:50 am

    #646078

    Set the format code of the textbox to d

  • June 27, 2006 at 4:17 pm

    #646244

    thanks

  • June 28, 2006 at 9:04 am

    #646390

    Susan,

    For me, whenever I change the format to d, the format is defaulting to standard again. So, I changed the format to dd/MM/yyyy and it worked for me.

  • June 28, 2006 at 3:11 pm

    #646499

    all different date formats you could try is here
    very useful one .

  • June 28, 2006 at 7:20 pm

    #646536

    Thanks for the tip.

    I just add extra CONVERT(varchar,getdate(),103) as today in my proc.

     

    I thought I can just easily grab the datetime functionality in VS2005 unfortunately I can't

     

     

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply