Force date format

HCL Domino Domino Forum
1

Hi,

I’m looking for a way to force a certain date format. In our company we use Notes all over the world, using different regional settings, sometimes even different Windows versions (Notes is always in English though). Problem we sometimes see is that dates are different using the different regional settings, even when the field properties are set to custom to display for example mm-dd-yy, on some people’s replicas we see dd-mm-yy for example. On others it even more bizarre the date displays correctly, but when it’s used for something (calculate a checksum, compose a URL,…) it’s different.

Any ideas on how to lock a date format?

2

Subject: force date format

the way the field stores a date is not that important since the field knows which value correspond to which part of the date it has. if you use the field to calculate a value, you can either1. for ce the field to have a set date in the field’s property,

put custom and force the format on the field.

  1. have a second TEXT field that computes the date using the initial field usung a formula;

e.g.:

@Year(fieldName)+“-”+@month(fieldName)+“-”+@day(fieldName)

you can create your own format and manipulate the data any way you want.