4 Replies Latest reply on Jul 4, 2016 3:47 AM by Adnan Khan

    Date question: The day name changes to number when moving to live connection, I use Datename function

    Adnan Khan

      Hi,

       

      I use the below calculated field to create weekday name out of date field. As long as I use an extract it shows weekday name as Monday, Tuesday...upto Sunday. The moment I change the connection to live (from extract) the format changes to 1,2,3,4,5,6,7 with 1 representing (Sunday), 2 Monday etc.

       

      DATENAME('weekday',[Date],'MONDAY')

       

      Please advise how can I fix this.

       

      Thanks,

      Adnan