2 Replies Latest reply on Oct 4, 2012 7:47 AM by BENOIT LEGRAND

    Date Function and Format

    BENOIT LEGRAND

      Hi all,

       

      I use the DATE function to generate a date in a calculated field.

       

      I have two servers : one French server and one U.S. server. The workbook must be deployed on both servers.

       

      The calculated field doesn't seem to work because the DATE function does not recognize the format of my date. Format on the French server is "DD/MM/YYYY" on the U.S. server "MM/DD/YYYY".

       

      Is there a way to specify the format to use ? Or another way around this problem ?

       

      Thank you