>hi Jon:
>
>Thanks for the reply -- VP_PPConfs.Posting_Date is a datetime value, so it is possible that I need to use one of the other date functions to get the date portion.. Right now, the formula is returning false instead of the date, for both instances, and my datediff formula is returning 0.
>
>I will change it and see what happens. Thanks again
>
>Regards
>Haydn
Haydn,
TTOD() will convert a datetime value to a date.
HTH,
Jim