How to convert date to plain text like ()20221001112830

rama

I am trying to convert the date(2022/10/01 11:28 AM 30 sec) into 20221001112830 this format can any one help how it will be get it done.

Thanks

Andrée Starå

Hi @rama

I hope you're well and safe!

Try something like this.

=
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
Convert@row, "/", ""), ":", ""), "AM", ""), "sec", ""), " ", "")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!