I am trying to design a view in Lotus Notes in a way that when retrieving data via NotesSQL into Crystal Reports 11 - the fields that ARE date, DISPLAY as date ( not strings ).
I know I can convert them when in Crystal but it's much nicer if it happens by default.
Have tried setting the columns as Date/Time but no effect at the Crystal end. ( still appear as Strings ).
The NotesSQL driver had a option "Return Notes Implicit Fields", when turning this on and going into Crystal I can see fields that were previously hidden such as:
- NoteCreated ( type DateTime )
- NoteAccessed ( type DateTime )
- NoteID ( type number )
These columns are not displayed in the view so I do not know what settings to use. When I create a column using "Simple Function" - CreationDate - it still only appears as a string in Crystal.
I have tried the Crystal Forum and they suggested using another driver. Reference:
Any help greatly appreciated, thanks for reading ;)