Forum Discussion

Chippy's avatar
Chippy
Frequent Visitor
1 year ago

Date Format

How can I make this text format in a dd mm yy format? Using the normal DateValue it seems to give me dates in future eg 7 Dec instead of 11 July?    
Show and Tell
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
1 year ago

Hi Chippy 

 

Use Change Type -> Using Locale then choose a locale that uses the d/m/y format e.g. Australia or the UK

 

 

NOTE: In this image I've chosen the Data Type : Date, if you want to preserve the time part of your data, choose Date/Time instead

 

 

 

Regards

 

Phil