Need Help with 'Timing' Formula

+17

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?

+17

I hope please someone can help me, PLEASE

+4

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.

Sign up