10-17-2017 09:54 PM
I have a variable called _datadate. The format of this variable is "MMDDYY10." Our data date ranges from 05/01/2015 to 07/31/2017.
I have two questions. First, I need to delete all of the dates before 05/15/2015. I use the following code to attempt this, but it does not work. How will I be able to accomplish this?
IF _datadate GE 05/15/2015 then OUTPUT;
The second question is as follows:
I want to get all of the DD values equal to 14 and 15. I want a function that will detect all of 14th and 15th of each month. How can I do this?
10-18-2017 12:40 AM
1.check the list of functions - DAY()
2. Date liberals are specified as 'ddMONyyyy'd or ‘01Jan2017’d
All of this is documented here: