How Do I Include The Time Function

[burton]

i have just managed to include the time in my database for my it project. iam having problems with the date function. i would like to find out how to make the date function work. iam doing a video renatl so it would be ideal to have a booking form so i would be able to calculate when the bookings expire. any help would be muchly appreaciated

 

[Fizzio]

In your table, you could set the default value for BookingDate as =Date()
Then you can calculate the returndate by using the DateAdd function eg

me.txtReturnDate = DateAdd("d",NumberofDays, me.txtBookingDate)

HTH

 

[burton]

where abouts would this go

 

[Fizzio]

It depends how you want to use it