April 26, 2023, 9:28am
I though this was simple and I’m pretty sure I’ve done it before. Calculating the days between now and the date of record creation.
But no matter what I do it end up giving me 0, But I’m expecting a 1 as the log date was yesterday.
I have the following:
I’ve tried to put the Truncation in caps none caps. But still don’t work.
Am I doing something completely wrong?
If it’s less than 1 day (ie. less than 24 hours),
trunc will round down to zero.
Round(Now - Date)
Or if you wanted it to always round up, you could use
Ceiling(Now - Date)
April 26, 2023, 10:22am
@Darren_Murphy, Round did the trick.
Ceiling gave me 1 but for logs created today would also gie me one.
It’s basically needed to format dates into today, yesterday etc… but I think round works
April 27, 2023, 10:23am
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.