1 Reply Latest reply on Oct 2, 2018 5:48 AM by Shinichiro Murakami

    Format date different between DataSources

    BAUDET Test

      Hi

       

      First of all sorry for my bad english.

       

       

      I have a server where i create and publish my datasource. In a DataSource i have a calculated filed with dd/mm/yyyy and it work.

       

      DATE(

      RIGHT([Date Creation],2)

      +"/"

      +MID([Date Creation],5,2)

      +"/"

      + LEFT([Date Creation] ,4)

      )

      => my result is for exemple : 30/09/2018

       

       

      When i publish the DataSource the field become mm/dd/aaaa.and the date is wrong

      => My result is wrong  => "null"

       

       

      Why ?

       

       

      best regards