What is the Access SQL syntax for comparing only the date portion of two date time fields? Branden
B Branden Nov 29, 2005 #1 What is the Access SQL syntax for comparing only the date portion of two date time fields? Branden
F fredg Nov 29, 2005 #3 What is the Access SQL syntax for comparing only the date portion of two date time fields? Branden Click to expand... You can use DateValue([SomeField]) or Int([SomeField])
What is the Access SQL syntax for comparing only the date portion of two date time fields? Branden Click to expand... You can use DateValue([SomeField]) or Int([SomeField])
J John Vinson Nov 29, 2005 #4 What is the Access SQL syntax for comparing only the date portion of two date time fields? Branden Click to expand... WHERE DateValue([DateFieldA]) = DateValue([DateFieldB]) John W. Vinson[MVP]
What is the Access SQL syntax for comparing only the date portion of two date time fields? Branden Click to expand... WHERE DateValue([DateFieldA]) = DateValue([DateFieldB]) John W. Vinson[MVP]
