Formula to display how many days since (start date)

Hi everyone, I hope you’re all well. Looking for a little help. It seems so easy i can’t believe i haven’t figured it out yet. Perhaps you can try.

Request:

All i need is to count days passed/elapsed since a start date - but it needs to displays DAYS ONLY.

I tried:

DATETIME_DIFF({Order Date}, TODAY(), ‘days’)

Problem here is that it displayed a “-” negative value. example -5, -15, -33

Page 1 / 1

Use DATETIME_DIFF that allows to specify the unit.

Try: DATETIME_DIFF(TODAY(),{Order Date},‘days’)

this worked perfectly. so simple.

problem however, it displays the negative value. how can I make it not display in negative numbers

Use DATETIME_DIFF that allows to specify the unit.

works but, problem, it displays the negative value. how can I make it not display in negative numbers

this worked perfectly. so simple.

problem however, it displays the negative value. how can I make it not display in negative numbers

you need to switch the order so today() is before {order date} and it will show positive so long as date is in the past

thanks tyler and thanks elias - you guys replied in 2 minutes with working solutions.

you two are rock stars.

Sign up