Probably a noob question but how do you do a compa...
# suiteanalyticsa
AI1
06/22/2022, 7:14 PMProbably a noob question but how do you do a comparison of a date against TODAY in SuiteAnalytics? In Saved Searches I would just do {today} - {date1} and it would show the number of days before today the Date1 is....however, {today} doesn't work in SuiteAnalytics
n
Netsuite Tragic
06/24/2022, 1:52 AMuse CURRENT_DATE
Netsuite Tragic
06/24/2022, 1:55 AMWell that was just a part of the solution when I try to do a simple Current_date - {trandate} when I validate I get
"Formula definitions that use DATETIME values with MINUS operations are currently not supported when the return type is INTERVALDS. Use CAST_TO_DATE(argument of DATETIME type) instead."a
AI1
06/24/2022, 2:04 AMHi @Netsuite Tragic thanks. I forgot to follow up that I figured it out. You are exactly right. Had to do CAST_TO_DATE(CURRENT_DATE) to get it to work