Getting A View Column Type

HCL Domino Domino Forum
1

I have some lotusscript which exports a view. However, I need to know whether any given column is in date format.

NotesViewColumn.DateFmt returns 0 if it’s in the year month day format (which is always used in my firm).

NotesViewColumn.TimeDateFmt returns 0 if it’s in the date only format (which is widely used in my firm)

The problem is, both of these properties return 0 if the column isn’t a date column at all.

Does anyone know a good way of telling if a column is set for Date/Time? I am currently having to rely on the column title containing the word “Date” which isn’t very reliable.

Thanks

2

Subject: RE: Getting A View Column Type

There’s no such thing as a view column type. All you can really do is read a few rows, test their datatypes, and make assumptions based on that, that the rest of the view might have the same datatype in that column. It’s hard to know which columnvalues line up with which columns since they are not all necessarily represented there, but you can always evaluate the column formula in the context of the document and see what you come up with.