MY TASK:
I need COUNT for PAST DUE records for a date field column that is populated?
do I use datediff?
Select Count (*)
DATEDIFF (D, datevalue1, CURRENT_TIMESTAMP) <-1
MY TASK:
I need COUNT for PAST DUE records for a date field column that is populated?
do I use datediff?
Select Count (*)
DATEDIFF (D, datevalue1, CURRENT_TIMESTAMP) <-1
Don't forget quotes,
DateDiff("d",date1,date2)
Thanks ranman256, can you explain how the <-1 works; does it mean, 1 day late?
This record can close.