INSERT INTO xxxx VALUES ('Store Name',..whatever..., '1', timestamp);

if in Server SQL maybe

INSERT INTO xxxx VALUES ('Store Name',..whatever..., '1',
current_timestamp);

else

INSERT INTO xxxx VALUES ('Store Name',..whatever..., '1',
''''+FormatDateTime('mm/dd/yy hh.mm.ss')+'''' might work

==========================================

Lee Catlett wrote:

>
> Can someone verify the correct way to do this if possible?
>
> INSERT INTO xxxx VALUES ('Store Name',..whatever..., '1', timestamp);
>
> Can't seem to get the timestamp to work
> Lee Catlett
>