Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Transform the formula to date format

Topic Labels: Formulas
Solved
Jump to Solution
1807 2
cancel
Showing results for 
Search instead for 
Did you mean: 
11110
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m wondering how I can transform the formula to date format. I have the date 15/04/2019 20:46, but I got it using formulas. Now I need to add some days, thats why I’m going to use DATEADD. But there is some problem. How I know we can use DATEADD just with date format.

1 Solution

Accepted Solutions
Julian_Kirkness
10 - Mercury
10 - Mercury

I’m assuming that this is because your formula date is being considered a string - you should be able to convert it to a Datetime with the following:

DATETIME_PARSE({Formula Date},‘DD/MM/yyyy hh:mm’)

I hope this helps?

See Solution in Thread

2 Replies 2
Julian_Kirkness
10 - Mercury
10 - Mercury

I’m assuming that this is because your formula date is being considered a string - you should be able to convert it to a Datetime with the following:

DATETIME_PARSE({Formula Date},‘DD/MM/yyyy hh:mm’)

I hope this helps?

Yes, thanks! :heart_eyes: