Hey Julia,

I would add this formula to your query module beforehand: LEFT(TABLE.COLUMN, 10) and then only use the formatDate(Confirmed for; DD.MM.YYYY) in the CSV module.

Hope this solves your issue.

BR

Julia

Hi Juilia,

thank you for your answer. When trying this, I get the following ERROR massage:

BR

Julia

Hi @julia.oppen11,

To extend on @julia.bauer's solution, the LEFT operator only works with columns of type STRING. In that sense, you must first cast the datetime column to string using TO_STRING.

Here is some documentation TO_STRING (celonis.com)

Hope this will help you!

Kind regards,

Sverre Klein

Hi Sverre,

the problem is, that I need the type Timestamp, as the date I will show in the CSV in the end, need to be the ROUND_MONTH and this is not possible with the type String.

BR,

Julia

Within the Create CSV module, what is the data type you're sending?

If you're sending this as a date, Excel will read the timestamp in. If you send as text, it'll send in whatever format you put together.

I'd also recommend putting together a "Set Variable"/"Set Multiple Variables" module before the CSV setting the date format and then passing the formatted date into the CSV. I've found it runs smoother that way.

Hi Matt,

I do not have the possibility to select a TYpe within the CSV module:

I will try to add the "Set Variable"/"Set Multiple Variables" module, but I don't know whether it solves my problem.

@julia.oppen11 : You can see and change the data type within the Data Structure "SWF_Delivery Reliability by clicking on the three dots ans select "Edit".

Okay where it says Data Structure, click the 3 dots.

You should see 'Edit' and 'Clone'. Click Edit.

Edit should bring you to the screen of the format of the different columns.