create date time from 2 text boxes

[Guest]

i have 2 text boxes which get submited to a action page i need to convert this to a SQL datetime so i can input it.

the format is
date form = dd/mm/yyyy
time form = hh:mm:sss

i am having trouble with the dd and mm being swoped around.

[Dan_Bracuk]

Use the left, mid, right, and createdate functions for the date formfield.

For the time one, are you really asking your users to type out the number of seconds?

[Guest]

are there any tutorials on create date left mid right?

[Dan_Bracuk]

Usage is described in the cfml reference manual. If you don't have one, the internet does.

To find a tag, google <cftagname> x, where x is the cold fusion version you want. To find a function, google coldfusion function-name x. I gave you 4 functions. createdate is all one word.

[Guest]

ok i have worked out the issue!!

the date is converting fine now, but the time is not, only the hour is correct so if my user selects "12/02/2008" and "16:48:00"

the output is "12/02/2008" and "16:00:00"

any ideas how to get the actual whole time to convert my code is below

<CFSET smsDate = CreateDate(form.year, form.month, form.day)>
<cfset SMS_Time = '#form.SMS_Time#'>

<cfscript>
tz=createObject("component","timeZone");
hours=listFirst(SMS_Time,":")+listGetAt(SMS_Time,2,":")/60+listLast(SMS_Time,":")/360;
smsDate=dateAdd("h",hours,smsDate);
serverDate=tz.castToServer(smsDate,"Australia/Sydney");
</cfscript>

[Dan_Bracuk]

There's a createdatetime function that's likely to work.

By the way, what happens if your form values are:
year = 2008
month = 6
day = 31

[Guest]

ok thanks Dan, that date is not valid so users woulndt be able to select it from the calendar.

createdatetime would be good just not sure where to set the time?

before the script to convert to server time?

[Guest]

Hi can someone please help me with this?

i need the date and the time converting not just the date as it is now?