Lotus Notes Datatypes are all strings

[roody91]

I am new to Crystal Reports. Using version 8.5 Pro. When I read in a Lotus Notes view all of the fields are string datatypes. Even those that are truly Date/Time fields. How can I correct this so I can do a record selection based on a date/time value?

Thanks,

Frank B.

 

[mbarron]

It would depend on how the date string is format. What does the string look like when you use it on your report?

Mike

 

[mbarron]

If your Lotus is like my Lotus, your date string looks like this: "2001/05/03 10:52:32.5"

If this is the case, use this formula;
date(tonumber(left({Date<String>},4)),
tonumber(mid({Date<String>},6,2)),
tonumber(mid({Date<String>},9,2)))
Mike