I know a little bit of Classic ASP but am having problems with date formatting and Access Database.
I am looking for some code that I can add into existing web pages to do the following.
User clicks on an icon to record a contact with a customer
This posts current date, current time, customer name into a MS Access database.
The user can also post a planned future customer contact using a date picker that posts future date and customer name to a MS Access database
The user can then run a series of queries of how many times they contacted particular customers, who they havent contacted, how many days ago since last contact with a customer etc.
My problem is I tried to develop this but the system records a mix of American (mm/dd/yyyy) and European (dd/mm/yyyy) date formats in Access so running a query of comparing dates is impossible.
When posting todays date [ date() ] it appears in Access database in American format
When posting future date from date picker it appears in Access database in European format
I want to be able to count the days between today and a date posted in the database but cannot do that if its in American format.
I want everything to be in European date format.
I have tried [url removed, login to view] but it didn't seems to work
I want something that is pretty simple. This is not a commercial website, it is for an internal intranet for the sales staff in our office so it doesn't need to be very complex.