I'm working on a custom window in Dexterity, and I need to calculate the number of days between two dates. Is there a way to do this with Dexterity? I originally thought about using the day() function, but quickly realized that would only work if the two dates were in the same month. Any help or ideas would be greatly appreciated.
Thanks,
Bill
*This post is locked for comments
This worked perfectly thank you. I never even tried that. I just assumed it was going to return a date not just number of days.
Dexterity allows you to do a simple straight up subtraction between two date fields, which returns a long integer value representing the number of days between the two, i.e.,
local long date_diff; date_diff = '(L) Start Date' - '(L) End Date';
You can call the RW_DiffDate() Report Writer user-defined function that already takes care of this:
Share
Report
All responses (
Answers (
local long date_diff;
date_diff = RW_DiffDate('(L) Start Date', '(L) End Date');
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156