Time to Formula Help

[Abraham_Bochner]

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?

[Abraham_Bochner]

I hope please someone can help me, PLEASE

[Julian_Kirkness]

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.