[Reply To] RE: Tiem Format problems
Fantastic - thanks very much Seamus You wrote This works in cfmx 6.1 > > > > >#DateFormat(plus17h, "dd mmm ")# #TimeFormat(plus17h, "HH:MM")# > > >It doesn't work on CF5 though (it fails on the .0) >On cf5 you could do a workaround > > > > > >Pascal > >> -Original Message- >> From: Seamus Campbell [mailto:[EMAIL PROTECTED] >> Sent: 22 September 2004 13:27 >> To: CF-Talk >> Subject: [Reply To] Re: [Reply To] RE: Tiem Format problems >> >> 2004-09-21 22:06:13.0 >> >> Ta >> >> Seamus > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] Re: [Reply To] RE: Tiem Format problems
2004-09-21 22:06:13.0 Ta Seamus You wrote Actually what do get if you do cfoutput of the date field without any >formatting? > >Andrew. > > >On Wed, 22 Sep 2004 11:46:35 +0100, Andrew Dixon <[EMAIL PROTECTED]> wrote: >> Is your data and a date or a datetime? >> >> Andrew. >> >> >> >> >> - Original Message - >> From: Seamus Campbell <[EMAIL PROTECTED]> >> Date: Wed, 22 Sep 2004 20:05:10 +1000 >> Subject: [Reply To] RE: Tiem Format problems >> To: CF-Talk <[EMAIL PROTECTED]> >> >> Access >> >> You wrote >> >> > Or is there a way to add 17 hours to the date in the database? >> > >> >What database are you using? >> > >> >-- >> >Jay >> > >> > >> > >> > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] Re: [Reply To] RE: Tiem Format problems
It's Date/Time in Access Ta seamus You wrote Is your data and a date or a datetime? > >Andrew. > > >- Original Message - >From: Seamus Campbell <[EMAIL PROTECTED]> >Date: Wed, 22 Sep 2004 20:05:10 +1000 >Subject: [Reply To] RE: Tiem Format problems >To: CF-Talk <[EMAIL PROTECTED]> > >Access > > You wrote > > > > Or is there a way to add 17 hours to the date in the database? > > > >What database are you using? > > > >-- > >Jay > > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Reply To] RE: Tiem Format problems
Actually what do get if you do cfoutput of the date field without any formatting? Andrew. On Wed, 22 Sep 2004 11:46:35 +0100, Andrew Dixon <[EMAIL PROTECTED]> wrote: > Is your data and a date or a datetime? > > Andrew. > > > > > - Original Message - > From: Seamus Campbell <[EMAIL PROTECTED]> > Date: Wed, 22 Sep 2004 20:05:10 +1000 > Subject: [Reply To] RE: Tiem Format problems > To: CF-Talk <[EMAIL PROTECTED]> > > Access > > You wrote > > > Or is there a way to add 17 hours to the date in the database? > > > >What database are you using? > > > >-- > >Jay > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Reply To] RE: Tiem Format problems
Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell <[EMAIL PROTECTED]> Date: Wed, 22 Sep 2004 20:05:10 +1000 Subject: [Reply To] RE: Tiem Format problems To: CF-Talk <[EMAIL PROTECTED]> Access You wrote > Or is there a way to add 17 hours to the date in the database? > >What database are you using? > >-- >Jay > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] RE: Tiem Format problems
Access You wrote > Or is there a way to add 17 hours to the date in the database? > >What database are you using? > >-- >Jay > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] Re: Tiem Format problems
thanks (wow very quick reply!) however I get this message when I try and use my date in the database ( rather than Now() ). "Entity has incorrect type for being called as a function. The symbol you have provided date_last_modified is not the name of a function." Any clues? You wrote Hi. > >This works. > > > > #DateFormat(plus17h, "dd/mm/")# #TimeFormat(plus17h, "HH:MM")# > > >Andrew > >- Original Message - >From: Seamus Campbell <[EMAIL PROTECTED]> >Date: Wed, 22 Sep 2004 19:36:48 +1000 >Subject: Tiem Format problems >To: CF-Talk <[EMAIL PROTECTED]> > >hi > > I'm trying to pull a date/time from a database then add 17 hours > to it and display in > > dd mmm h n > > format > > I thought I could add 17 hours to the date using DateAdd but this > seems to have problems with the format > and > I can't work out how to get the time to be plus 17 hours > > Or is there a way to add 17 hours to the date in the database? > > Help please > > Seamus > > Seamus Campbell Boldacious WebDesign > http://www.boldacious.com [EMAIL PROTECTED] > ph 02 6297 4883 mob 0410 609 267 > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
