Solved

How to convert a data field in date text format "AUGUST 20,2025" to date format "08/20/2025" in ACS workflow?

Looking to see if there is a way to convert date provided in text format "AUGUST 20,2025" to numeric date format "08/20/2025" in ACS workflow?

And then , check if that numeric date is prior to today's date.

Best answer by SatheeskannaK

@deepanshu_bhatnagar Take a look at these functions.

Accepted solution

Community Advisor

@deepanshu_bhatnagar Take a look at these functions.

Thanks, Sathees

Level 2

@deepanshu_bhatnagar Not likely to be done in ACS that simply. You would have to use a combination of functions:

Replace() to remove space and ',' so you have something like "AUGUST202025"
Use Iif() to transform each month into a numeric value. Output should be like "08202025"
Then you should be able to use the dateformat to have "08/20/2025"

Sign up