Answered

Change the date format as dd-MM-yyyy

(0) Share

Report

Posted on by mohamed18

Hi everyone

I have a cell "date" in a excel sheet which is in a date format, but on flow I have this error message when I format the date in dd-MM-yyyy: Unable to process template language expressions for action 'Condition_2' at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '44683' was not valid. The datetime string must match ISO 8601 format.

Can someone give me some advice

Thank you

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

CU31011410-0 142 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you're after converting the date then this might help you:

It can be found using this method:

Some screenshots of your flow and data output might help others assist you as it's not easy reading what you're trying to do or your steps. You can snip and paste directly into replies.

Was this reply helpful? Yes No
mohamed18 43 on at

Like (0)

Report
Copy link

Link copied!

I still have the same error message, I think it's due to the date which is provided by excel to PA as "44683" but the format is set to date on excel

Was this reply helpful? Yes No
Verified answer

RobElliott 10,428 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Excel stores dates as an integer. If you are using a List rows present in a table action make sure you select the DateTime format in the action to ISO 8601.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
mohamed18 43 on at

Like (0)

Report
Copy link

Link copied!

Thank you @RobElliott, my flow is working fine now !!

Was this reply helpful? Yes No