469,167 Members | 1,946 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

DateDiff - Do You See The Problem??

Access chokes on this.....Anyone see the problem??
Expand|Select|Wrap|Line Numbers
  1. AgeInDays: DateDiff("d"[now()],[date recvd])
Jan 21 '09 #1
4 1071
8,800 Expert 8TB
Expand|Select|Wrap|Line Numbers
  2. AgeInDays: DateDiff("d",Now(),[date recvd])
Jan 22 '09 #2
THANKS, Mr Expert!!!!!!!!!!!!
Jan 22 '09 #3
8,800 Expert 8TB
You are quite welcome.
Jan 22 '09 #4
32,167 Expert Mod 16PB
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.

Similar topics

8 posts views Thread by inamori | last post: by
6 posts views Thread by Lofty | last post: by
4 posts views Thread by Paolo | last post: by
3 posts views Thread by chanchito_cojones | last post: by
1 post views Thread by John T. | last post: by
6 posts views Thread by kevinjwilson | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.