Convert String (mm/dd/yy) to Date format

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I have the following column with dates -

how can i convert this to a date? I eventually want to take the date string and subtract 30 days from it to get a new date.

trying this -

getting error -

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string 'Date' was not valid. The datetime string must match ISO 8601 format.'.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
@wonka1234
addDays([insert original date],(number of days to add/negative number to remove),'date-format-here')

addDays([insert original date],-30,'yyyy-MM-dd')
Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@creativeopinion thanks. However I think my string needs to be converted to date format before i can add days..i think...

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Hello @wonka1234

Have you tried ParseDateTime?

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
@Matthy79 tried - parseDateTime('Date','en-US','yyyy-MM-dd') getting error

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'In function 'parseDateTime', the value provided for date time string 'Date' was not valid. The datetime string must match ISO 8601 format.'.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
@wonka1234 Try this:
addDays(formatDateTime([insert date here]),-30,'yyyy-MM-dd')

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

But you say your date is in a different time format. Why are you parsing it as „yyyy-MM-dd“?

Please just add your date (without any expression) to a compose action and show the output.

Was this reply helpful? Yes No