I'm at a loss here. Had a search that ran just fin...
# suiteanalyticsc
Corey Schwoebel
05/25/2022, 2:34 PMI'm at a loss here. Had a search that ran just fine last week, but shows invalid expression errors now as I try to run it. Is this a defect, or am I doing something wrong?
s
Sandii
05/25/2022, 3:05 PMif the system date format settings changed then those dates might be invalid now
Sandii
05/25/2022, 3:06 PMYou could also put your formula in suite analytics instead, it has a formula checker
d
Dominic B
05/25/2022, 3:09 PMChange to TO_DATE('11/15/2021','MM/DD/YYYY') etc
c
Corey Schwoebel
05/25/2022, 4:14 PMThanks to both of you. Using the second argument for the TO_DATE function, in my case M/D/YYYY, fixed the issue.