Formula to display how many days since (start date)


#1

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


#2

Use DATETIME_DIFF that allows to specify the unit.


#3

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


#4

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


#5

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


#6

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


#7

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

you two are rock stars.