Dear all expert,
I have a problem with end user date format issues. All our company PC date time formate is set to dd/mm/yyyy. But one of our end user, when she submit a form, the date format from her is change to dd-mm-yyyy.
We had perform checking on her PC where all the region setting is correct. Then we ask her to test submit the form in others PC, it is still the same. Is it related to her user profile or? Kindly please advice as i am freaking headache with this issue.
Thank You
Subject: If you store the date as a date field then it wont matter what format the end user has their machine set to.
What headache are you getting? If you are storing dates as strings, then you will get lots of headaches.
Subject: Date format.
Hi, Thank you for your response.
The date field is always set as date format. We had a standard for all our applications. and this issues only happen to one of our end user. Only the document came from her will have this problem.
Thank you.
Subject: Not what you said in your response in the other forum
@Text(@Date(@Now)).
That formula is not storing the date as date/time it is storing it as text.
Subject: Date Format.
Hi Carl,
Thank you for your response. I just wondering if there is any other way to solve this issues. Since, the only way had been suggested, I will try it out.
Thank you.
Subject: Roaming profile
Check if the user has roaming profile enabled, in this case his/her profile will be used on any computer.If you are using the date in a log field, you should add the date with formula or LS.
In formula you can use the @year, @month, @day function, and in LS the format(, “dd/mm/yyyy”) for exymple.