Hi Team,
In the date column, we want to show the date in the format MM-DD-YYYY without the time. We have applied this format in the application. When we export the data to Excel, the format looks accurate. However, when we export to CSV, the date appears as MM-DD-YYYY HH:MM:SS. Below are the snapshots for your reference. Please review and assist.
Thanks !
Hi @tdr_Dinesh,
This is interesting, what format is your actual date field setup as (prior to you customizing the format)?
I wonder if you tried using formatDate to create your custom format instead of the option above…if you replace your date field with the calculated field, does the export still show the same result?
Hi @tdr_Dinesh
As suggested by @Brett, try using the formatDate function to formats a date using a pattern you specify.
**Example: **
formatDate(OrderDate,'dd-MM-yyyy')
