Time Intelligence Intepreting US Date when its UK Date sequence
Hi,
I have a date time field formatted as dd/mm/yyyy hh:mm:ss
Sample 21/09/2019 00:00:00
But Time Intelligence is interpreting is as mm/dd/yyyy hh:mm:ss
Server System time has been checked as UTC and dd/MM/yyyy
How can I convince Pyramid to interpret the Date correctly for non-US format please
Kind Regards,
Stuart
1 reply
-
Hi Stuart,
Which type of datasource are you using in the Data Flow?
All the SQL based should automatically read the date with the right format.
if the problem occurred on Excel / Text file, you can do the follow steps to resolve the problem:
1. on the Select node, on the Column Selection panel you can change the Date column to type string.
2. use convert column node, and change the string node to Date / Date time, with provided format
Let me know if you need any additional help.
Thanks,
Shai.
