AnsweredAssumed Answered

Calculate Car hire Status

Question asked by tobyc on May 2, 2018
Latest reply on May 2, 2018 by tobyc

Hi all,

How do I write executesql query to display the car hire's status based from the bookings table which has fields of hire date, return date and status.

Status has a value list of: Available, Hired, Service.

See attached for table

 

TIA

Attachments

Outcomes