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!

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

DateDiff returning 0

Status
Not open for further replies.
ba4crm

ba4crm

Technical User
Dec 19, 2003
92
US
I am using MS Access 97 and am trying to get the difference between two dates [CloseDate] and [CreationDate]. In the instance when the two dates are the same, is it possible to have the calculation display 1 instead of 0? I am using "=DateDiff("d", [CreationDate],[CloseDate])"

Thank you for your help
 
Sort by date Sort by votes
= IIF(DateDiff("d", [CreationDate],[CloseDate])=0,1,DateDiff("d", [CreationDate],[CloseDate]))"

 
Upvote 0 Downvote
Oops,

Just scratch that last quote mark at the end....
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

NeilT123
  • Locked
  • Question
need -0.104000000000013 to show as 0 in report 1
Replies
4
Views
106
NeilT123
NeilT123
h2mhd
  • Locked
  • Question
hide report lines with subtotal = 0
Replies
3
Views
80
dhookom
dhookom
zjzastava
  • Locked
  • Question
Dislpay DateDiff reluts in a report
Replies
4
Views
65
zjzastava
zjzastava
bkel
  • Locked
  • Question
need 0 were blanks on report
Replies
3
Views
40
bkel
bkel
christophercubitt
  • Locked
  • Question
Report not returning specific information
Replies
9
Views
56
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top