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?
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
I am not sure if this is the best way to sahre as I can not attach a file..bit in this sample you can see the original dates when converted to datevalue reverses some dates from dd mm to mm dd
Hi Chippy
I can't access that, it requires a login to your system.
You can put the file on OneDrive, Google Drive, Dropbox etc and then share the link to it.
Regards
Phil