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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Level 1

@deepanshu_bhatnagar Take a look at these functions.

Translate

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"

Translate

Sign up