RE: Date as a single variable

Tony Francis · Guest

O.K. - I admit defeat !!
There's obviously a way to do this, but I just can't figure it out.
What I have is a HTML form where the user inputs a whole heap of fields including a date.
What I am then doing is passing the data to a PHP3 file to process the sending of the data to an mSQL database.
What I can't figure out id how to get the date format as one expression instead of the 3 (day, month, year) that I have started with.
Be gentle with me - I'm just learning this stuff Smile

Any help would be gratefully appreciated and would also mean the few hairs I have remaining may last a while longer yet !!

scollo · Guest

In PHP you can use the dot (.) operator to concatenate the values in the variables. So if you need the date in YYYY-MM-DD format, you can:

$date = $year . "-" . $month . "-" . $day;

This will create the string "YYYY-MM-DD".

Or, if you need MM/DD/YYYY, do the same thing:

$date = $month . "/" . $day . "/" . $year;

Then use "$date" in your SQL statement.

--Chris

Tony Francis · Guest

Thank you - did the trick perfectly, and saved me hours more time in trying to discover the solution.

Cheers