10 Replies Latest reply: Oct 25, 2017 2:07 PM by Anand Chouhan RSS

    Regarding Converting Integer to MMM YYYY format

    ramesh konda

      I have created one pivot/Crosstab file in the excel with the below screenshot. when i import the file into the Load editor i'm able to see the below screen.

      SourceFile Format:

      Load Editor format :


      i'm unable to find the functions of converting the ( 41640,41671,.........) values to the above excel MON-YYYY format in my Table.

      Where i want to get the below format after loading.



      Need some Date conversation functions to work on these kind of conversations.