Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Need Help with 'Timing' Formula

Topic Labels: Formulas
400 2
Showing results for 
Search instead for 
Did you mean: 

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?


2 Replies 2

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.