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.
Solved
Transform the formula to date format
Best answer by Julian_Kirkness
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?
+4I’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?
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:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.