I have a Query , is it possible for us to change the date format in mega from MM/DD/YYYY to DD/MM/YYYY in Mega ?
Solved! Go to Solution.
In general the date format in HOPEX is the same as the Windows date format on the server where HOPEX is installed. Should you want to change the date you need to change the date format in windows.
The inconvinent is that it will change everywhere in the solution not only on the query.
Other option below.
Example for Windows 2012
For your information the date format is also configured on a text related to the language. This mean that you can also change it without changing Windows setting. My remarks stay the same as it will apply for the whole application not limited to query. The benefit is that it will be applied only to this language. It can have some use if some of your users have DD/MM/YYYY (for French) and some MM/DD/YYYY (for english).
The procedure to change it can vary with the version of HOPEX. But below is some explaination :
With a user allowed to update MEGA data
yy is year
MM is month
dd is day
separator is a string used to separate date from time (space char., dash char.), ex separator= -
am is a string indicating that the hour is before midday, ex: am=am
pm is a string indicating that the hour is after midday, ex: pm=pm