20 Replies Latest reply: Feb 22, 2016 3:11 PM by Marco Wedel RSS

    Issue with Date

    Priyanka Pandey

      Hi All, I have an excel file containing attendance records of all employees in the format specified below.

         

      Employee #NamesTeam NameDesignationWork status01-Jan-16 Fri02-Jan-16 Sat03-Jan-16 Sun04-Jan-16 Mon05-Jan-16 Tue06-Jan-16 Wed07-Jan-16 Thu
      1PriyaITAnalystActivePPPPPPP
      2PriyankaITAnalystActiveAAAAPPP
      3MonikaFinanceAnalystActivePPPPPPP
      4SarveshAdminAnalystActivePPPPPPP

       

       

      And I want it to load it in below format

         

      Employee #NamesTeam NameDesignationWork statusDateAtt_Value
      1PriyaITAnalystActive01/01/2016P
      2PriyankaITAnalystActive01/01/2016A
      3MonikaFinanceAnalystActive01/01/2016P
      4SarveshAdminAnalystActive01/01/2016P
      1PriyaITAnalystActive02/01/2016P
      2PriyankaITAnalystActive02/01/2016A
      3MonikaFinanceAnalystActive02/01/2016P
      4SarveshAdminAnalystActive02/01/2016P
      1PriyaITAnalystActive03/01/2016P
      2PriyankaITAnalystActive03/01/2016A
      3MonikaFinanceAnalystActive03/01/2016P
      4SarveshAdminAnalystActive03/01/2016P
      1PriyaITAnalystActive04/01/2016P
      2PriyankaITAnalystActive04/01/2016A
      3MonikaFinanceAnalystActive04/01/2016P
      4SarveshAdminAnalystActive04/01/2016P
      1PriyaITAnalystActive05/01/2016P
      2PriyankaITAnalystActive05/01/2016P
      3MonikaFinanceAnalystActive05/01/2016P
      4SarveshAdminAnalystActive05/01/2016P
      1PriyaITAnalystActive06/01/2016P
      2PriyankaITAnalystActive06/01/2016P
      3MonikaFinanceAnalystActive06/01/2016P
      4SarveshAdminAnalystActive06/01/2016P
      1PriyaITAnalystActive07/01/2016P
      2PriyankaITAnalystActive07/01/2016P
      3MonikaFinanceAnalystActive07/01/2016P
      4SarveshAdminAnalystActive07/01/2016

      P

       

       

      But the issue I am facing is with the date column. It is getting loaded in number format. I tried converting it into date format using date and date# function but couldn't achieve desired result.

       

      I need your suggestions.

      Thanks in advance

      -Priyanka