Action flow CSV Formatting

Hi Nick, that’s actually a quick fix which you need to implement in the action flow itself. 

1. Open the “Create CSV” module. 
2. Go to your date column and use the formula “formatDate” for your column:

3. 

   In my example I used the format “YYYY-MM-DD hh:mm” to get the following output: “2026-04-15 14:52”. You simply need to use the format you expect.

4. Test by running the module only and checking the output.

I hope this helps!

Cheers,

Denis

Hi I will try this!

I ended up fixing it manually with updating the KPI to this formula vs the formatting on the KPI.

CONCAT(YEAR("INVOICE_PROCESSING"."INVOICE_DATE"), '-', MONTH("INVOICE_PROCESSING"."INVOICE_DATE"), '-', DAY("INVOICE_PROCESSING"."INVOICE_DATE"))

Hi ​@Nick.Monteleone, 

Dates in Celonis are in Unix-Epoch format, being milliseconds after 01-01-1970 stored as an integer. This is exactly what you see in your Excel. Converting it to a String would solve it visually as you did and ​@Dennis suggested. If you want to maintain its numerical functions (i.e. doing calculations with it), you can keep it as integer and let Excel do the formatting (for example: https://exceljet.net/formulas/convert-unix-time-stamp-to-excel-date).

Best regards,

JP