>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.Haydn,
For starters, it looks like DateDiff() will accept datetime parameters so you may not even need to convert them to date types.
Secondly, if you are entering formulas using Basic syntax instead of Crystal syntax, then you need to use the DateValue() function instead.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer