Hi,

I have two asp pages - one is a form with hidden fields
called manualDate with value <%=Date()%> and ManualTime
with value <%=Time()%>

The next page contains a DRW with the INSERT INTO
SQL...trouble is, I am getting problems with the dates.

Here is my code:

INSERT INTO table (a,b,c) Values ('::a::',::b::,::c:

It is the b,c that are causing the problem as a is a text
box field.

I think I have to use @ or # but I have forgotten - can
someone please help??

Skc

If you're using an Access database, date/times are delimited with '#'
characters.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"skc" <(E-Mail Removed)> wrote in message
news:18fbe01c44c76$0dedd9c0$(E-Mail Removed)...
> Hi,
>
> I have two asp pages - one is a form with hidden fields
> called manualDate with value <%=Date()%> and ManualTime
> with value <%=Time()%>
>
> The next page contains a DRW with the INSERT INTO
> SQL...trouble is, I am getting problems with the dates.
>
> Here is my code:
>
> INSERT INTO table (a,b,c) Values ('::a::',::b::,::c:
>
> It is the b,c that are causing the problem as a is a text
> box field.
>
> I think I have to use @ or # but I have forgotten - can
> someone please help??
>
> Skc