3 Replies Latest reply: Jan 12, 2018 9:07 AM by Sunny Talwar RSS

    Make Date from 3 character Month; Ex: Apr

    Dan Green

      I have a year field and a month field that shows Jan, Feb, Mar, Apr, etx. My load script also already has :

       

      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

       

      It is probably easy but I cannot seem to get these fields in a format such as Apr 2017. The issue is I need to create a rolling 12 month flag so I didnt think Month&' '&Year would work. Any help is appreciated.

       

       

      Thank you!