Færdiggjort

Classic ASP Coding

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.

Evner: ASP

Se mere: web pages icon, i want to develop my existing website, intranet ms, icon sales, coding of web pages, i need sales staff, ms access 2013, little bit of everything, date picker, classic name, classic asp, classic asp user, access database problems, using code record date time, asp date picker, iis running asp classic, recursive query parent child asp classic, internal record system, complex intranet, last days query

Om arbejdsgiveren:
( 4 bedømmelser ) Dublin 6, Ireland

Projekt ID: #4948684

Tildelt til:

shmai

Ready to start!!

€47 EUR på 1 dag
(172 bedømmelser)
6.9

4 freelancere byder i gennemsnit €71 på dette job

cheapexcell

I can help you with this issue

€45 EUR på 1 dag
(7 bedømmelser)
3.6
amanmahal07

Will provide you with quality [login to view URL]

€48 EUR in 3 dage
(9 bedømmelser)
3.2
freelancer5299

We can 100% deliver what you need. Check PM for more info.

€144 EUR in 3 dage
(0 bedømmelser)
0.0