Date Calculation

[rxm01l]

I have Date Field in my database which I want to setup a calculation. Exaple, If the Curent Date is NOT FRIDAY, it would Add 1 to the Curent Date, on the other hand , if Current Date is FRIDAY, I would like to add 3 on to Current Date.. Reason behind this is that if users signed out a book today "If today is Not Friday" , they will have to return tomorrow "the next day", But if Today is Friday, the can return on Monday.. Is this make sense? I'm new at this.. Thanks in advance...

 

[plog]

You would need to use the Weekday function (http://www.techonthenet.com/access/functions/date/weekday.php).

=DateAdd("d", iif(Weekday(Date())=6, 3,1), Date())

 

[rxm01l]

Thanks So much for a quick response...I'll try this out...Again .. ThankYou..