Reporting from Notes databases

[australia3]

I am trying to report from Notes databases containing date fields. I'm told that the date fields are actually text fields so do I need a formula to convert them and what is it? I'm new to reporting from Notes databases and non-relational databases, can anyone recommend a text book that includes basics or an online course perhaps?

 

[synapsevampire]

Place one of the field on your report, right click it and select browse data.

This will show you it's data type, and then post it as well as the format of the field.

Logically, the conversion is based on what's in there.

You can just try cdate({table.field}), but it may not work.

Often you need to parse it out into some understandable format for Crystal using string functions such as left and mid along with the cdate.

-k