07-21-2016 12:19 PM
Hey all. I'm trying to create a new dataset with a WHERE condition on a variable that is in DAY format. Here's the code:
SET RCOST_OUTAGE_DUP (WHERE = (DAY_MO = 1));
I get 0 records when I should get 2. Any ideas?
07-21-2016 04:10 PM
If you have applied a DAY format then the original value is a DATE value and and the normal comparison would be use a date literal in the form of 'ddMONyyyy'd.
SET RCOST_OUTAGE_DUP (WHERE = (DAY(DAY_MO) = 1));
To use the DAY function to return the day of the month from the date variable.