3 Replies Latest reply: Nov 15, 2017 7:09 AM by Sunny Talwar RSS

    Date from YearMonth

    wajiha khan

      Hi

       

      I have a field say 'A' which has YearMonth like this (200903). From that field i want to create a date field in this format 01/03/2009

      How is this possible in script? Below is sample script.

       

      Load

           A,

           Month(date#(A,'YYYYMM')) as Month,    /* Month Name (Jan,Feb,Mar...)

           Num(Month(date#(A,'YYYYMM')),'00') as [Month Number],   /* Month Number (01,02,...,12)

           Year(date#(A,'YYYYMM')) as Year,    /* Year (2009,2010...)

       

      Thanks