Highlighted
Regular Contributor

Date Flipping from UK to US style

Hi,

I am importing data froma  csv into a  module and i have 7 date fields, they are all formatted (short date) exactly the same as each other, when i import the data, i have ticked the format to show D-M-Y which correctly showed the dates and applied to all date fields as normal..

However when i import, 6 of the fields are correct and the last one is flipping the day and month to US style.This obviously creates many problems, but how can I fix this please?

2 REPLIES 2
Highlighted
Certified Master Anaplanner

Re: Date Flipping from UK to US style

Hi,

 

I would be easier to identify the issue if there is some screenshot/sample data.

Highlighted
Certified Master Anaplanner

Re: Date Flipping from UK to US style

Hi,

 

I prefer to load data to transactional flat list and refer to it using "SUM". It allows to load date to a text formatted property and get it in a module using formula. If you don't load csv directly into a module, this may help you

 

Regards,

Hayk