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 -
Share
Report
909Unable 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.'.
@wonka1234 Try this:
addDays(formatDateTime([insert date here]),-30,'yyyy-MM-dd')
@Matthy79 tried - parseDateTime('Date','en-US','yyyy-MM-dd') getting error
All responses (
Answers (
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.'.@creativeopinion thanks. However I think my string needs to be converted to date format before i can add days..i think...
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! |
