How to Format a date mm-dd-yy hh:mm:ss to dd-mm-yy? Thank you
Subject: Formatting a date
One other thing …
The format of the date returned from @Date if displayed depends upon the internationalisation settings on the client (if the @Date is being executed in the client) or on the server (if @Date is being executed on the server).
If you always want @Date to return dd/mm/yyyy instead of mm/dd/yyyy then you could determine whether the settings can be changed in your environment.
Subject: Date format conversion
If you look in designer help for the function @Month and look at the example given you’ll see an example of how to format like so:
This formula returns a formatted date string based on the contents of the dueDate field. For example, if dueDate contains “06/26/95” the formula returns June 26, 1995. If dueDate contains “01/24/96 3:40:43 P.M.,” the formula returns January 24, 1996.
space:= " ";
comma:=“,”;
month:=@Select(@Month(dueDate);“January”;“February”;“March”;
“April”;“May”;“June”;“July”;“August”;“September”;“October”;
“November”;“December”);
day:=@Text(@Day(dueDate));
year:=@Text(@Year(dueDate));
month + space + day + comma + space + year
You’d have to change it a bit to get the exact format you need.