Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 20 Nov 2009 at 1:44pm
Weird. Never had a problem with that formula.
I am guessing as I have not seen that before but try:
if isnull({tblWilliamsGrantExpenditures.Date}) or {tblWilliamsGrantExpenditures.Date}<Date(1900,01,01) then 'Various' else totext({tblWilliamsGrantExpenditures.Date},'MM/dd/yyyy')
Joined: 23 Jan 2009
Location: United States
Online Status: Offline
Posts: 159
Posted: 20 Nov 2009 at 1:52pm
That did the trick! Now that I see the formula, I can understand how it works. As for me trying to come up with this formula by myself, there is not enough time in the week.......Thanks for your efforts.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum