Notes Date/Time Problem

HCL Domino Domino Forum
1

We have just moved a load of databases to US servers from the UK. One particular db has a form that captures when visitors are arriving and leaving in Notes/Date time format. A tempdate field then captures these dates and explodes all the dates in-between in a text list. e.g. If I was visiting on the 1st Oct, Leaving 5th Oct, the tempdate field would show 1/10/2010,2/10/2010,3/10/2010 etc

The problem is that in moving the db to the US, the view which shows ‘By Date’ is using the text list field temp dates, so those visting on the 5/10/2010 is actually showing under 10/5/2010. So the question is, is there any way to explode the dates but keep them in a Notes/date time format?

2

Subject: Re: Notes Date/Time Problem

Try following:1> Change the column style to Date-Time (4th Tab - Column properties) and set the custom display setting for the column. You will require to put the column formula like @TextToTime(tempField)

Or

2> Changed the format of the date in temp field for all existing document to “mm/dd/yyyy” and update your form to save it in same format for new documents, when they are created or modified.

HTH