how to change date format in date variable in a record producer?

[georgechen]

Greeting folks, 

I would like to ask you gurus how to change the date format in a date variable within a record producer.   In my personal instance, in a dummy record producer where a date variable exists, if I type '4/5/2018' (see below screenshot)

and then jump to next object (or tab key - lost focus), it automatically converts to '0004-05-20' which is unexpected as users would not know what that is?

When submitting the form, it creates an IN record (as it's mapping to incident table)

it populates as 2018-04-05 which is yyyy-mm-dd but I want to it to in the format of Australia of dd-mm-yyyy.

I've checked 'System Localization' under System Properties but not sure where to configure the variable date format.

Any advice would be appreciated. 

Thanks,

George

[SanjivMeher · Accepted solution]

Check System Properties->System and look for Date Format. Also if user record has a different format, it will override the system format for that user.

[georgechen]

Much appreicated Sanjivmeher, it worked like a charm on the format!!

I will need to investigate why the month and day reverses in the question_answer table (e.g entering 4/5/2018 -> question answer captures as 2018-04-05 , which is incorrect in Australian it is meant to be 2018-05-04) I think I will raise with HI for further support as this happens to my personal instance as well as all of my organisations' instances.

[leboute]

Looking for potential ways to automate have different formats (overrides to the global property) per application scope and/or automate format based on user country field or similar locale information at user record level. Probably a business rule to manipulate user's preference based on other fields plus an initial load script for all users would do. Anyone knows of a simpler way for it?