Format Date from Text

How To
1

How can I format this TEXT “20230616” as a Date like this MM/DD/YYYY?

So it should be as date 06/16/2023

Just the date NO time

2

Hi @Sam_Krausz

To solve your issue, please use the parseDate() and formatDate() functions as shown below:

image
image1282×626 78 KB

If you need assistance, don’t hesitate to contact me.

Best Regards,

Msquare Automation
:point_right: Visit our website | :spiral_calendar: Book a free consult

3

Hello @Sam_Krausz :wave:

@Mohamed_Jahar is giving you the right pointers here.

If you wanted to learn more about Date and time functions, you can check out this guide we have in the community:

1 Like