I have a asp form that submits fields to a SQL database. One of the fields is a date field split into 3 drop downs (day, month and year). On submit these fields populate day, month year field in my MS SQL database.
1. How can i merge these 3 fields via a query into a standard date format dd/mm/yyyy
2. how can I then count the number of days passed from this date to the current date ?