Jul 10, 2018 12:53 PM
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
Jul 10, 2018 01:01 PM
Use DATETIME_DIFF that allows to specify the unit.
Jul 10, 2018 01:01 PM
Try: DATETIME_DIFF(TODAY(),{Order Date},‘days’)
Jul 10, 2018 01:03 PM
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:
Jul 10, 2018 01:03 PM
works but, problem, it displays the negative value. how can I make it not display in negative numbers :slightly_smiling_face:
Jul 10, 2018 01:04 PM
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
Jul 10, 2018 01:06 PM
thanks tyler and thanks elias - you guys replied in 2 minutes with working solutions.
you two are rock stars.