Steve
|
| Posted: 05/20/2002, 7:31 AM |
|
Attempting to insert a date to a record.
Using SQLServer
field in the DB =
COL NAME DATA TYPE LGNTH ALLOW NULLS
link_date smalldatetime 4 yes
Field defined in Code Charge =
NAME DEFAULT DATA TYPE
link_date =now() date
This is the data I get while viewing the page
{ts '2002-05-20 10:24:32'}
I need to know how to format this date to something I can use (I do not
care about the time, just the date)
Thanks
Steve
|
|
|
 |
Steve
|
| Posted: 05/20/2002, 7:58 AM |
|
OK I may have solved this my self , placed the following in BEFORE SHOW
<CFSET fldlink_date=Dateformat(fldlink_date, "mmmm dd, yyyy")>
"Steve" <groningasc@navair.navy.mil> wrote in message
news:acb1bv$2q6$1@news.codecharge.com...
> Attempting to insert a date to a record.
>
> Using SQLServer
>
> field in the DB =
> COL NAME DATA TYPE LGNTH ALLOW NULLS
> link_date smalldatetime 4 yes
>
>
> Field defined in Code Charge =
> NAME DEFAULT DATA TYPE
> link_date =now() date
>
> This is the data I get while viewing the page
> {ts '2002-05-20 10:24:32'}
>
> I need to know how to format this date to something I can use (I do not
> care about the time, just the date)
>
> Thanks
>
> Steve
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 05/21/2002, 1:23 AM |
|
What was your CC version ?
--
Alex
CodeCharge Developer
"Steve" <groningasc@navair.navy.mil> wrote in message
news:acb2tu$5sb$1@news.codecharge.com...
> OK I may have solved this my self , placed the following in BEFORE SHOW
> <CFSET fldlink_date=Dateformat(fldlink_date, "mmmm dd, yyyy")>
>
> "Steve" <groningasc@navair.navy.mil> wrote in message
>news:acb1bv$2q6$1@news.codecharge.com...
> > Attempting to insert a date to a record.
> >
> > Using SQLServer
> >
> > field in the DB =
> > COL NAME DATA TYPE LGNTH ALLOW NULLS
> > link_date smalldatetime 4 yes
> >
> >
> > Field defined in Code Charge =
> > NAME DEFAULT DATA TYPE
> > link_date =now() date
> >
> > This is the data I get while viewing the page
> > {ts '2002-05-20 10:24:32'}
> >
> > I need to know how to format this date to something I can use (I do not
> > care about the time, just the date)
> >
> > Thanks
> >
> > Steve
> >
> >
>
>
|
|
|
|
Steve
|
| Posted: 05/21/2002, 6:32 AM |
|
2.0.5
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:acd06g$l9v$2@news.codecharge.com...
> What was your CC version ?
>
> --
> Alex
> CodeCharge Developer
>
>
> "Steve" <groningasc@navair.navy.mil> wrote in message
>news:acb2tu$5sb$1@news.codecharge.com...
> > OK I may have solved this my self , placed the following in BEFORE SHOW
> > <CFSET fldlink_date=Dateformat(fldlink_date, "mmmm dd, yyyy")>
> >
> > "Steve" <groningasc@navair.navy.mil> wrote in message
> >news:acb1bv$2q6$1@news.codecharge.com...
> > > Attempting to insert a date to a record.
> > >
> > > Using SQLServer
> > >
> > > field in the DB =
> > > COL NAME DATA TYPE LGNTH ALLOW NULLS
> > > link_date smalldatetime 4 yes
> > >
> > >
> > > Field defined in Code Charge =
> > > NAME DEFAULT DATA TYPE
> > > link_date =now() date
> > >
> > > This is the data I get while viewing the page
> > > {ts '2002-05-20 10:24:32'}
> > >
> > > I need to know how to format this date to something I can use (I do
not
> > > care about the time, just the date)
> > >
> > > Thanks
> > >
> > > Steve
> > >
> > >
> >
> >
>
>
|
|
|
|
|
