Question about Convert Date-Time Field in CR7

[stormtrooper]

I went to the help and looked this up. It says that it will convert a date-time field from Microsoft Access to string, date or date-time. So does this mean that it will not work for a DB2 database?

 

[synapsevampire]

Is the date field in number format in the DB2 database?

If so, you can still convert it, check:

http://support.crystaldecisions.com/library/kbase/articles/c2008156.asp

Are you experiencing a problem?

-k

 

[stormtrooper]

Actually I just gave it a try and it works. The problem was actually my formula and that I had a (-1) inside the parentheses instead of outside. But I had a couple of options, one was to do the conversion and the other, which I took, was to investigate my formula. Anyhow, everything is good.

Thanks.