Formula to display how many days since (start date)

[Benzo]

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

[Elias_Gomez_Sai]

Use DATETIME_DIFF that allows to specify the unit.

[Tyler_Kurlas]

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

[Benzo]

this worked perfectly. so simple.
problem however, it displays the negative value. how can I make it not display in negative numbers :slightly_smiling_face:

[Benzo]

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

[Tyler_Kurlas]

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

[Benzo]

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

you two are rock stars.