This content has been marked as final. Show 2 replies
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 ?