Skip to main content

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?


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.

Reply


Terms & Conditions