Forum Discussion
Error when converting from date/time to date
Hi
Getting an error while trying to convert from date/time to date
The original date format is
MM/DD/YYYY HH:MM
and I want to have just DD/MM/YYYY.
the original date is being pulled from a file in a sharepoint folder.
Maybe the source is formated as US locale?
I want to use the UK locale instead.
Thanks
Anonymous,
You may add a custom column as follows.
DateTime.ToText(DateTime.From([Date created]), "dd/MM/yyyy")
1 Reply
Anonymous,
You may add a custom column as follows.
DateTime.ToText(DateTime.From([Date created]), "dd/MM/yyyy")