Forum Discussion
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?
Thanks, This did not seem to work..I am wondering if it is due to the date formats not being consistent eg days drop the leading zero but months have a leading zero.
Hi Chippy
No that shouldn't matter - download this file for an example.
When you say it didn't seem to work - why do you say this? What result did you get when you tried what I suggested?
Please provide the actual data you are using - even better would be the file with the data in it.
Regards
Phil