The date was in American format MM-dd-yyyy and we wanted dd-MM-yyyy.
Granted, a user can change this for themself but this is not what I want, dammit!
Anyway, after some searching around in conjunction with the excellent scanEZ from Ytria, I stumbled upon the following solution.
Create a button with the following formula
@SetField("$DWADateFormat";"dd-MM-yyyy");Select the appropriate Mail Policy Settings document (assuming you've already got one) and click your button.
@SetField("$DWADateFormat$UP";"2")
The next time the mail policy is applied, the default date setting will be be dd-MM-yyyy for the users that use that Mail Policy Settings document.
To further explain this, a user's setting in iNotes are (mostly) controlled by a profile document in their mail file called inotesprofile.
There are a number of fields in this profile document that don't have a corresponding UI setting in the Mail Policy Settings document.
To set the field, prefix it with $DWA, so in relation to the above code the field DateFormat in the inotesprofile document will be set to dd-MM-yyyy.
To determine how the setting is applied prefix the field with $DWA and suffix it with $UP. So, as above $DWADateFormat$UP is set to 2 in the Mail Policy Settings document. This equates to the setting Set value and prevent changes
If you require a different setting, use the mapping below:
- Don't set value - set the $DWADateFormat$UP to "1"
- Set initial value - set the $DWADateFormat$UP to "3"
- Set value whenever modified - set the $DWADateFormat$UP to "5"
- Set value and prevent changes - set the $DWADateFormat$UP to "2"