Change date format, time format in ARS server side workflow objects (filter, escalation)
Encountering  issue which a filter will always returning date in format "mm/dd/yyyy", no matter how I change the server region and locale settings.

In the documentation (BMC Remedy AR Server Configuration Guide) it says that you can change server end date time format by setting environment variable like ARDATE in UNIX and use language and regional settings in Windows Control panel.

This is a bit misleading as I have set the values manually by environment variables in both UNIX and Windows system then restart AR service and they does not seems to be working. Using filter to return "DATE($TIMESTAMPE$)" value are still in "mm/dd/yyyy" format, despite I have already change format to "dd/mm/yyyy".



 

Legacy ID:KA359099

The only way to change the date time format for server side workflow objects is to set the variable in armonitor.cfg (armonitor.conf) file like this for example

Environment-variable: ARDATEONLY=MM/dd/yyyy
or
Environment-variable: ARDATEONLY=dd/MM/yyyy

depending the desired output.

Will make "DATE($TIMESTAMPE$)" to return date in "dd/mm/yyyy" format. Remember that the "MM" part must be in upper case.

The armonitor parameter is also documented in the configuration guide, it is just the "change server end date time format by setting environment variable like ARDATE" part in the same document that is misleading
Note:  The date format settings are different between Unix and Windows.  For example ARDATE "%m/%d/%y"  using the percent sign character (%) is for Unix/Linux platforms.

See the online documentation using the link below for more details:
https://docs.bmc.com/docs/ars91/customizing-date-and-time-formats-609071343.html