View Single Post
 
Old November 21st, 2005, 06:25 PM
Steven Steven is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try using:
Code:
(DateDiff("m",Date(),DateSerial(Year([RenewDate])+1,Month([RenewDate]),Day([RenewDate])-1)
))
instead. Put the entire expression in the column rather than referencing a separate calculated column




I am a loud man with a very large hat. This means I am in charge