Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Transform the formula to date format

Topic Labels: Formulas
Solved
Jump to Solution
865 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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: