By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

DateDiff - Do You See The Problem??

P: 24
Access chokes on this.....Anyone see the problem??
Expand|Select|Wrap|Line Numbers
  1. AgeInDays: DateDiff("d"[now()],[date recvd])
Jan 21 '09 #1
Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,597
@dryjeans
Expand|Select|Wrap|Line Numbers
  1.  
  2. AgeInDays: DateDiff("d",Now(),[date recvd])
  3.  
Jan 22 '09 #2

P: 24
THANKS, Mr Expert!!!!!!!!!!!!
Jan 22 '09 #3

ADezii
Expert 5K+
P: 8,597
@dryjeans
You are quite welcome.
Jan 22 '09 #4

NeoPa
Expert Mod 15k+
P: 31,186
It's also highly inadvisable to use the Now() function when you really want the Date() function. Now() includes the time element as a fraction, so is not the same as a simple date.
Jan 23 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.