locked
Date Format DD/MM/YYYY RRS feed

  • Question

  • Hi There!

     

    Saw that are many post about this, but none answered my question!

    I´m using the Today() function as default value, but this one is displayed in: MM/DD/YYYY but i wanna that the default value be on format: DD/MM/YYYY

    The string i´m using right now is: =Today().ToShortDateString

     

    Can some one help me?....


    ------------------------------------------------------------- Oracle OCA11g
    Wednesday, March 30, 2011 6:19 PM

Answers

All replies

  • try

    Format(Today,"dd/MM/yyyy")


    Ted Krueger Blog on lessthandot.com @onpnt on twitter
    Please click the Mark as Answer button if a post solves your problem!
    • Proposed as answer by onpnt Wednesday, March 30, 2011 6:32 PM
    • Marked as answer by Tony Chain Thursday, April 7, 2011 9:47 AM
    Wednesday, March 30, 2011 6:22 PM
  • Solved for today, but my other parameter is yesterday, how i get this date in format dd/MM/yyyy? 
    ------------------------------------------------------------- Oracle OCA11g
    • Marked as answer by Fabrizzio Caputo Wednesday, March 30, 2011 6:31 PM
    • Unmarked as answer by onpnt Wednesday, March 30, 2011 6:32 PM
    Wednesday, March 30, 2011 6:22 PM
  • Same way but put the parameter in the Format.  e.g. Format(Parameters!Yesterday.Value,"dd/MM/yyyy")

     


    Ted Krueger Blog on lessthandot.com @onpnt on twitter
    Please click the Mark as Answer button if a post solves your problem!
    Wednesday, March 30, 2011 6:25 PM
  • Solved to!
    ------------------------------------------------------------- Oracle OCA11g
    Wednesday, March 30, 2011 6:30 PM