>- see footer for list info -<
What DB are you using?

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul Swingewood
Sent: Thursday, September 29, 2005 9:56 AM
To: [email protected]
Subject: [CF-Dev] Aggghhh! - Its driving me mad!

>- see footer for list info -<
Back to my calendar application again ....

I have a variable StartDate which I know holds 29/9/05 for example .....

If I run the code below all is well and {ts '2005-09-29 00:00:00'} gets 
written to the database.
All is working fine .... UNTIL

StartDate = 7/9/05

Then the code decides its going to insert {ts '2005-07-09 00:00:00'}

This is driving me nuts .... can anyone help me please. If I use
dateformat 
will I loose the time element? - Aghhhh!


The code (its in a <cfscript> block)

// Add times to the dates and parse.
      StartDateTime = ParseDateTime(StartDate & " " & StartTime &
":00");
      EndDateTime = ParseDateTime(EndDate & " " & EndTime & ":00");


Regards - Paul

You can see this at www.bgfl.org/cfpages/calendar


_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
-<

_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to 
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<

Reply via email to