How to change the format of dates and datetimes in input boxes

Gonçalo Gaiolas

Question

Hi everyone!

A new feature that was released with version 3.1.3.18 is the ability to set the format of dates and datetimes on input boxes. This means that you're no longer limited to use the yyyy-MM-dd format to input your dates.

To acomplish this, you can use the following SQL instruction on your database :

update ossys_Parameter set Val = 'yyyy-MM-dd' where Name = 'dateFormat'

where Val can take the following values : 'yyyy/MM/dd', 'dd/MM/yyyy', 'MM/dd/yyyy', 'yyyy-MM-dd', 'dd-MM-yyyy','MM-dd-yyyy' (where yyyy stands for year with four digits, MM month with two digits and dd for days with two digits).

After changing this you need to re-publish your previously existent eSpaces so that they take advantage of this feature. Any newly published eSpace will automatically use the specified date format.

Please note that this feature affects date formatting server wide, meaning that all eSpaces published in the server will be affected after re-publishing.

As a final note, I would just like to mention that this feature's configuration will be available on Service Center in the upcoming 3.2 version.

I hope you enjoy this new feature! Have fun!

05 Jan 2006

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines