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)

Sort by

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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
Copy link

Link copied!

@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,188 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @wonka1234

Have you tried ParseDateTime?

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

Like (0)

Report
Copy link

Link copied!
@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,508 Moderator on at

Like (0)

Report
Copy link

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

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

Like (0)

Report
Copy link

Link copied!

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