I am able to show when a date field is less than t...
# suiteanalyticsm
mg2017
02/17/2022, 2:36 PMI am able to show when a date field is less than today - is it possible to show the difference between the two days, meaning show the accrued number of days?
k
KevinJ of Kansas
02/17/2022, 3:43 PMShould just be able to subtract them.
KevinJ of Kansas
02/17/2022, 3:44 PMIf it's returning a value that includes extra digits than you want to see you can do
to_char({field A},'j') - to_char({field B},'j')m
mg2017
02/17/2022, 5:15 PMThanks, but when I tried to subtract it gave me an invalid expression error
k
KevinJ of Kansas
02/17/2022, 7:38 PMYou did it as a formula numeric?
KevinJ of Kansas
02/17/2022, 7:39 PMI've done it that exact way hundreds of times
2 Views