UK Vs US date formats

HCL Domino Domino Forum
1

I have a field (data type string) containing dates in format “dd/mm/yyyy”.

I used a simple NotesDateTime property to achieve that:

Set dt=New NotesDateTime(Cstr(entries))

Call rtitem.AppendText(Format(Cstr(dt.LSLocalTime),“d”))

Problem occurs when the same application is accessed by a client in UK. For example - if the date is 4/11/2009, for UK client, the date is picked up as 4 but for US client, the date is picked up as 11.

How do I expect the client to get a date (in string) in US format only?

2

Subject: Why store the dates as a string?

You make your life much harder by storing them as strings.

If you store them as data/time values then Notes does the hard work of displaying it as the right format for the user.