how to change the date format from default to other format.

[xren]

Hi Wai,

When I add a date field to a form, the default date format is dd/mm/yyyy. I would like to change it to yyyy/mm/dd. Where can I do this?

I changed the system.dateformat=yyyy/mm/dd in the ufssetup.properties file. But it seems that the server does not take the system date from from there. I saw the startup log in the console still show system date format is dd/mm/yyyy. (The server does take that ufssetup.properties file as configuration file.)

I restarted the server several times. It still the same.

Thanks,
Xiaoli

[Steve]

Hi Xiaoli,

The date format for the field is picked up from the International settings.

You need to go to Tools-->System Preferences-->Internationalization.

Inside here you can select the language and the settings to use.

Otherwise, I am not sure there is another way to do this.

[Wai]

Yes, you have to change the language in Internationalization as mentioned by Steve.

I think for CRCD project, I set the formatting language to en_ZA
It uses short date of: yyyy/MM/dd

[xren]

Thank you both Steve and Wai.
I changed it to en_ZA. Then the format changes to yyyy/mm/dd.

Hi Wai, my other question is that when I click "clear" button to clear some fields value, the calender after the date field disappeared as well. Is there any settings wrong? (I copied the enquiry page and made some changes)

[Wai]

I think this is because the the Calender is applied by JQuery? Is this your CRCD system? If so, the calenders are styled using JQuery UI.

This will be as a result of having Ajax turned on for the form and using JQuery's document.ready (on the page - html++) to apply the calender.

The problem here is that javascript you place into the page's document.ready will only be applied when the whole page is redisplayed. This works when Ajax on the form is turned off. Therefore, any changes you make to the form (immediate validation), causes the page to refresh.

At the time of writing CRCD (4.4.1), there was no way around this except disabling the Ajax on the form.

However, in 4.4.2, we introduced a new JQuery event

The ready event

Most events run in response to a user interacting with the page, e.g. clicking a button. The ready event is different – it is run when the page first loads, or when a control is shown from a previously hidden state and when Ebase refreshes the control (if Ajax has been enabled). This event can therefore be used to manipulate the control for display before it’s shown to the user. Typical examples might be to alter its style/class attributes or to configure the control as a JQuery UI widget.

For example, in the client script you may have had something like this which is added to the page:

Code: Select all

$(document).ready(function(){
	$(".datePicker").datepicker({
		showOn: "both",
		buttonText: '',
		buttonImage: "samples/images/themes/calendar.gif",
		buttonImageOnly: true,
		dateFormat: 'yy/mm/dd',
		showButtonPanel: false,
		changeMonth: true,
		changeYear: true
	});
});

With Ajax enabled, you will need to move this part below into the HTML Element Properties of the control (date field)

Code: Select all

$(".datePicker").datepicker({
		showOn: "both",
		//buttonText: 'Select Date',
		buttonText: '',
		buttonImage: "samples/images/themes/calendar.gif",
		buttonImageOnly: true,
		//dateFormat: 'dd/mm/yy',
		dateFormat: 'yy/mm/dd',
		showButtonPanel: false,
		changeMonth: true,
		changeYear: true
	});

This is found in HTML Element Properties - JQuery tab - Event drop down

Let me know how you get on.

[xren]

Hi Wai,

Then I think I should remove the crcd_generic from the page.
When add the code to the date field control, what event should I chose from the event dropdown list?

Thanks,
Xiaoli

[Wai]

Yes, remove the script from the page, add to the date control field. Select jquery event ready

[xren]

I did the changes and it works fine now.

I may have other questions later.

Thank you very much.
Xiaoli

[Wai]

That's great!

Feel free to post questions, please start a new thread for different topics and phrase them to the community if possible.

[LKirby]

Hi, im having the same problem as xren was.

I've got a date field that needs to be in the format yyyy/mm/dd and im using a jquery datepicker to enter the date (that works fine) but then if i click any other button on the page then an error message pops up saying that the date format is dd/mm/yyyy. so i went in into internationalisation options and set english (south africa) as a default as it has the short date i wanted but i still get the same error message

any ideas?

[Wai]

Can you check your Internationalisation settings and disable the option (options tab)

2. Try to honour the users browser setting

[LKirby]

yeah works fine now, figured it out a few mins after asking for help.
thanks anyway