Xavier
|
| Posted: 05/08/2002, 1:35 AM |
|
Hello,
I've a timestamp column in a PgSql db.
In the corresponding CC record form field I've set
=Date("d.m.Y, G:i")
as default value and Date as data type.
Html checkbox is unchecked.
Inserting a new record results in an empty date field. What is wrong?
Thanks
Alex LL
|
|
|
 |
Barry G. Sumpter
|
| Posted: 05/08/2002, 1:58 AM |
|
Hi Alex,
Not sure about the language but vbscript is more like this;
=format(date(),"yyyy mm dd mmss")
=format(date(),"short date")
baz
"Xavier" <nobody@nowhere.invalid> wrote in message
news:abao0a$vbq$1@news.codecharge.com...
> Hello,
> I've a timestamp column in a PgSql db.
> In the corresponding CC record form field I've set
> =Date("d.m.Y, G:i")
> as default value and Date as data type.
> Html checkbox is unchecked.
> Inserting a new record results in an empty date field. What is wrong?
>
> Thanks
> Alex LL
>
>
|
|
|
|
Barry G. Sumpter
|
| Posted: 05/08/2002, 1:59 AM |
|
And I just noticed today that the =date()
defaults to your regonal setting.
baz
"Xavier" <nobody@nowhere.invalid> wrote in message
news:abao0a$vbq$1@news.codecharge.com...
> Hello,
> I've a timestamp column in a PgSql db.
> In the corresponding CC record form field I've set
> =Date("d.m.Y, G:i")
> as default value and Date as data type.
> Html checkbox is unchecked.
> Inserting a new record results in an empty date field. What is wrong?
>
> Thanks
> Alex LL
>
>
|
|
|
|
Xavier
|
| Posted: 05/08/2002, 2:10 AM |
|
"Barry G. Sumpter" <bsumpter@bigpond.net.au> ha scritto nel messaggio
news:abapb7$262$1@news.codecharge.com...
> Hi Alex,
> Not sure about the language but vbscript is more like this;
>
> =format(date(),"yyyy mm dd mmss")
> =format(date(),"short date")
>
>
I use php and this format:
=Date("d.m.Y, G:i")
should work good but it doesn't.
|
|
|
|
|
