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

[Deepanshu_Bhatnagar]

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.

[SatheeskannaK]

@Deepanshu_Bhatnagar Take a look at these functions.

https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-data/filte...

[TristanBerthon]

@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"