DateTime in Crystal and excel.

[pwilliams]

Does anyone know why when I do the following in Crystal :

CurrentDateTime - {datetimefield}

I get an answer that is one day less than the below in excel 97 :

Now-{datetimefield}

Any Answers/Ideas much appreciated, it's not causing me a huge problem it's just a bit perplexing.

Thanks,
Pete

 

[kenhamady]

Does your report convert datetimes to dates?
(See File - Report Options)

It would do that by eliminating the time and rolling it back to midnight which might cause a difference. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[pwilliams]

No it doesn't, it keeps datetime as datetime. the database in question however seems to default every time to midnight which may be the cause of this?

Thanks for the help!

 

[kenhamady]

Do you have a rounding issue?
Is the data live in Excel or imported?
Can you see the times used in all 4 values?

If this happens with identical values in both programs,then that would mean that the programs do their math differently which would surprise me. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[pwilliams]

It's live data in Excel (via SQL database link). And yes I can see the full field in both Crystal and Excel. Both excel and crystal are set to no decimal places.

Pete

 

[kenhamady]

If you really want to find the answer here is the test:

On a report put both date time values one for one record, and format them with the full time showing. Then put the Crystal net formula next to them with several decimal places.

Now using the same record, do the same thing in Excell. First, this will tell you which is the correct answer.

Then, if you post the 6 values in your next post we might have a clue as to why they give a different result. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal