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
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 :slightly_smiling_face:
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 :slightly_smiling_face:
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:
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
