clarion date time notation

[patrick118]

We have a clarion application that stores it's information in an oracle database.

I want some data out of it so I made a crystal report. All goes well except that i can't get the data notation correct.

When i put a day in for example i ask to see all clients off the data june 7 2005 crystal shows me this as 74671

Someone told me this is because clarion does some formula on the data so it shows correct in the application.

What is this formula so i can see the date correct in crystal?


patrick

 

[MisterMo]

I think you can make some sense by looking at this article

http://www.clarionmag.com/cmag/v4/v4n12exceldates.html

Mo

 

[patrick118]

Yep,

Great worked like a charm.

thank you

Patrick