Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Prasant T
  Where is Prasant T?
 Thrissur, Kerala
 India
 Prasant T
 Tags
Subject: Datediff in Access
Thread ID: 395375 Message ID: 395375 # Views: 44 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Tuesday, January 14, 2014 8:48:46 AM         
   


In MS Access query,

Select DateDiff ("d", #15/10/2003#, #22/11/2003#)

is returns 38.

Therefore the return value of Select DateDiff ("d", #05/10/2003#, #22/11/2003#) should be 48 but it returns 196.

Short date and Long date formats in system is dd/MM/yyyy.





Prasant

ENTIRE THREAD

Datediff in Access Posted by Prasant T @ 1/14/2014 8:48:46 AM
RE: Datediff in Access Posted by Borislav Borissov @ 1/14/2014 9:40:42 AM
RE: Datediff in Access Posted by Vilhelm-Ion Praisach @ 1/14/2014 10:28:43 AM
RE: Datediff in Access Posted by Prasant T @ 1/14/2014 10:47:59 AM