>- see footer for list info -< I guess the first thing I should ask is are the dates valid date time objects are they simple date representations of strings? If you use Now() do you get the correct date saved?
Kola > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:dev- > [EMAIL PROTECTED] On Behalf Of Paul Swingewood > Sent: 22 July 2005 11:15 > To: [email protected] > Subject: [CF-Dev] Help - PLEASE..!! > > >- see footer for list info -< > This is driving me nuts and I just can't figure out whats going on ....? > > I have two variables #request.startdate# #request.enddate# > > If I run this > > <cfoutput> > INC_EVENT_BEGIN_PROCESS > <p> > START - #Request.StartDate#<br> > END - #Request.EndDate# > </p> > </cfoutput> > <cfabort> > > I see that dates correctly as expected > > This part of a query inserts to an SQL table with the fields set as datetime > > VALUES ( > #Request.EventTypeID#, > '#Request.EventName#', > '#Request.EventShortDesc#', > NULLIF('#Request.EventDescription#',''), > '#Request.Location#', > NULLIF('#Request.EventURL#',''), > #lsdateformat(Request.StartDate, 'dd/mm/yyyy')#, > #lsdateformat(Request.EndDate, 'dd/mm/yyyy')#, > NULLIF('#Request.ContactName#',''), > > When I look in the table both dates are set to 01/01/1900 > > AGhhhh! - Im tearing my hair out on this one. Can anyone help me please. > (I've tried removing the lsdateformat but that didn't do anything :( > > Regards - Paul > > > _______________________________________________ > > 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 -<
