Short Date Export in CSV File

[DRomano]

I'm very new to this forum so please forgive my ignorane.

I'm trying to set a field for today's date to export from a "Results" page for each line item (row).

The only way I was able to this was by adding a Calculated Field using the formula "SysDateTime()".

That said, when I view the result it's in my preferred format of MM/DD/YYY.

However, upon export to a .csv file the export gives a result of a Long Date with the format of  M/D/YYYY H:MM.

Is there an easier way to do the export and with my preferred format in the .csv of just the short date (MM/DD/YYY) or a way to add to the formula to achieve my goal?

Thanks for any help in advance.

[sandy159]

Hello @DRomano,

Please  choose the Formatting on the Calculation Field and select Formatting: Custom,  Format type: Short date. 

Also you need to make sure that Short Date is in correct format in the Localization that you use for the DataPage.

Hope this helps!

[DRomano]

Thanks for the help!