Hello all, I couldn't find a thread that could help me, I did look for about an hour though. I have a character variable "DOB" in the form of MM-YYYY (i.e. 01-2000) that represents birthdays. I want to calculate the amount of time between a person's birthday and April 1, 2019 (it's the start of a specific fiscal year I'm interested in). The units (i.e. days, months, years) of the difference I calculate is not important (i.e. it could be anything) and rounding is OK too. My line of thought was to 1) convert "DOB" into a date variable in the form MM/YYYY; 2) Generate a date variable for April 2019 in the form of MM/YYYY (i.e. dropping the 1 to facilitate differencing); and 3) difference the variable created in Step 1) from the variable created in Step 2). However, I haven't been able to make any useful progress in doing this any thoughts or guidance would be appreciated. Regards, PatSB
... View more