Hello everyone,
my task once again is to design a video rental database. I have done all i need to but but am having problem in getting the due date. from the dateRented and DueDate. what query or code will i use? i will appreciate an urgent reply
Thanks Y'all.
Jump to Postif you posted it in a format that I could read you would stand a much better chance of an answer
if you posted it in a format that I could read you would stand a much better chance of an answer
ok
Use the dateadd function to find the duedate based on daterented and length of hire. if length of hire is in days then
duedate = dateadd("d",LengthOfHire,DateRented)
thanks i have figure that out
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.