Number column not maintaining date format reverting to numeric

Support
1

I have a file that has started dropping the the date format every time I exit and reopen it. While editing the file it keeps the date format dd-MMM-yyyy but when I save and re open it's back to 45433 for example and since this is an automated export it causes me issues.

It did work and stopped about the time I went to 5.8 I upgraded to 5.8.1.2 today and still the same problem. It appears to only happen with this one file so I'm not sure how to troubleshoot.

Open to ideas.

2

Hi Dan,

If you set the column format explicitly to a date format, and save the project, the formatting will remain as long as column name doesn't change.

image
image676×508 32.4 KB

3

So in every other project I have you are correct and this one used to be fine but now...

image
image1920×826 95.9 KB

Then I change the format
image
image1920×753 85.1 KB
And Save the project. Close it and reopen it and this is what I'm back to
image
image1920×679 88.8 KB

Which is why I'm at a loss

4

BTW my current work around is to Export my end table to a csv where the dates are numeric. Re-import that CSV and Easymorph converts the numeric to the proper format then re-export it overwriting the other file and then copy it to my S3 bucket for processing by my cloud app and that seems to be working. Again I'm not sure what sequence is corrupting the formatting process and I'd love to fix it but that is my current workaround

5

Can you please send the project to support@easymorph.com? We'll take a look at it.

6

Thank you, it as been sent

7

Hi @Dan_Stephens,

Thank you for providing the project file. We are currently investigating the issue. Could you please take a screenshot of the column's "Lineage" at the action where you are changing the format? You can access it by clicking the "Lineage" button.

394_u3ure3hkSv
394_u3ure3hkSv716×155 5.78 KB

Please provide a screenshot of the "Lineage" right after opening the project (when the format is missing) and another after you've changed the format to 'dd-MMM-yyyy'.
Additionally, could you check if the format of the column is the same before and after the 'Aggregate' action in the 'Keep Duplicates' table?

Thanks!