Change 2025-03-25 to 20250325

[LisaLeach]

Hello,

I am looking for the easiest way to remove the hyphens from a date 2025-03-25 to 20250325.  There should be a way in the Data Cleanse tool to remove dynamic characters.

[alexnajm]

not sure what you mean by dynamic characters, but it's because the output needs to be a string since your expected format is no longer a date

DateTimeFormat([field], "%Y%m%d") will work

[LisaLeach]

Oh right, a formula. I wasn't thinking.  Thank you.  

[alexnajm]

Happy to help! Please accept the response as a solution when you get a chance 😊