Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date and DateTime variable inconsistencies - any ideas

Status
Not open for further replies.

SBendBuckeye

Programmer
May 22, 2002
2,166
US
I have 2 Crystal Reports ver 8 which use the same SQL Server tables as their source. In a Basic Syntax formula editor where I am trying to do exactly the same calculation, one requires a variable to be datetime and the other allows it to be defined as date.

If I am doing date range arithmetic, will the time component of a datetime field impact the math?

Can anyone give me an idea of why this discrepancy might be occuring. I checked Report options and both show that DateTime fields should be treated as Date.

Thanks in advance for any help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top