Help

Need Help with 'Timing' Formula

Topic Labels: Formulas
744 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Abraham_Bochner
8 - Airtable Astronomer
8 - Airtable Astronomer

This is my formula

IF(DATETIME_DIFF(TODAY(),{purchase-date},'d')<1,DATETIME_DIFF(TODAY(),{purchase-date},'h'), DATETIME_DIFF(TODAY(),{purchase-date},'days'))

Why do I get all this results? Why is all this numbers negative?

Screenshot_120

2 Replies 2
Abraham_Bochner
8 - Airtable Astronomer
8 - Airtable Astronomer

I hope please someone can help me, PLEASE

Hi @Abraham_Bochner

Try the following:

IF(DATETIME_DIFF(NOW(),{purchase-date},‘days’)<1,DATETIME_DIFF(NOW(),{purchase-date},‘hours’), DATETIME_DIFF(NOW(),{purchase-date},‘days’))

It seems that NOW() is needed to include the time.

Hope this helps.