realhorrorshow
Technical User
I am having no luck getting the TO_DAYS function to work: (TO_DAYS(NOW()-60)), I have tried filling a static date and still no luck.
Any ideas?
THanks
Any ideas?
THanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TO_DAYS 1
- Thread starter realhorrorshow
- Start date
- Status
-
1
- #2
The expression should be
to_days(now())-60;
and not
to_days(now()-60);
You want to convert today's date to an integer first and then subtract 60 off it, rather than attempting to subtract 60 off a date represented as a string and then trying to convert to an integer date.
to_days(now())-60;
and not
to_days(now()-60);
You want to convert today's date to an integer first and then subtract 60 off it, rather than attempting to subtract 60 off a date represented as a string and then trying to convert to an integer date.
- Status