07-14-2014 11:39 AM
Could you please let me know how to convert character year-month to number MonYear. The sample data below.
Pt No. date_have(character) Date_need(numberic)
1001 2001-10 OCT2001
1002 2010-08 AUG2010
1003 2009-01 JAN2009
Thanks in advance
Need further help from the community? Please ask a new question.