cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Is it possible to change the date Format in Mega ?

Solved
Highlighted
Occasional Contributor

Is it possible to change the date Format in Mega ?

Hello ,

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  ?

 

Thanks 

Mounika

3 Replies
MEGA

Re: Is it possible to change the date Format in Mega ?

Hello,

 

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

  • Login to the server with the service account used for HOPEX
    Browse 'Control Panel > Clock, Language, and Region'
    Click 'Change display language'
    In the tab 'Format', select the expected format in 'Short date format'
Occasional Contributor

Re: Is it possible to change the date Format in Mega ?

Thnax for the reply ,

 

i will try out the solution you said and see what will be the impact of it.

 

Thanks

Mounika

MEGA

Re: Is it possible to change the date Format in Mega ?

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

 

  • Open a private workspace with the profile/role 'Mega Customizer'
    Configure option 'Access to metamodel' to 'Expert'
    Configure languages options to display the expected language
    Select the expected language using the query tool
    In the query result windows, select the expect language (ex: English)
    R click >Properties
    In the tab 'Characteristics', identify the text '_LanguageCharacteristics'
    Manually add the following lines following the syntax below
    Exit and dispatch private workspace


Full syntax:

[DateFormat]
date=yy-MM-d
time=HH:mm:ss
am=
pm=
separator=

 

Where
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