>- see footer for list info -<
Once you've broken your text-based dates into their parts, you can use:
CreateDateTime(year, month, day, hour, minute, second)
This returns:
{ts '2005-09-07 00:00:00'}
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: 29 September 2005 15:10
To: Simon Baynes; Coldfusion Development
Subject: Re: [CF-Dev] Aggghhh! - Its driving me mad!
>- see footer for list info -<
Thanks.
I don't care how its done as long as I get the ODBC date time thing in the
database in the form ...
{ts '2005-07-09 00:00:00'}
So can I use ....
StartDateTime = CreateDate(StartDate & " " & StartTime & ":00");
EndDateTime = CreateDate(EndDate & " " & EndTime & ":00");
Regards - Paul
***********************************************************************
The information contained within this e-mail (and any attachment) sent by
Birmingham City Council is confidential and may be legally privileged. It is
intended only for the named recipient or entity to whom it is addressed. If you
are not the intended recipient please accept our apologies and notify the
sender immediately, or telephone +(44) 121 464 4444 Unauthorised access, use,
disclosure, storage or copying is not permitted and may be unlawful. Any e-mail
including its content may be monitored and used by Birmingham City Council for
reasons of security and for monitoring internal compliance with the office
policy on staff use. E-mail blocking software may also be used. Any views or
opinions presented are solely those of the originator and do not necessarily
represent those of Birmingham City Council. We cannot guarantee that this
message or any attachment is virus free or has not been intercepted and amended.
***********************************************************************
_______________________________________________
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 -<
_______________________________________________________________________
Confidentiality: This e-mail and its attachments are intended for the above
named only and may be confidential. If they have come to you in error you must
take no action based on them, nor must you copy or show them to anyone; please
reply to this e-mail and highlight the error.
Security Warning: Please note that this e-mail has been created in the
knowledge that Internet e-mail is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when e-mailing us.
Viruses: Although we have taken steps to ensure that this e-mail and
attachments are free from any virus, we advise that in keeping with good
computing practice the recipient should ensure they are actually virus free.
_______________________________________________________________________
_______________________________________________
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 -<
