Update query and parameters

[Amin]

Hi,
I have a simple (hopefully) question. I want to set a field as today's date,
but not the time.

My query right now is the following:

UPDATE [mytable] SET DATEField = NOW();

Is there a simple command to not retrieve the time?

 

[Clifford Bass]

Hi Amin,

Sure. Use Date() instead of Now().

Clifford Bass

 

[John W. Vinson]

Hi,
I have a simple (hopefully) question. I want to set a field as today's date,
but not the time.

My query right now is the following:

UPDATE [mytable] SET DATEField = NOW();

Is there a simple command to not retrieve the time?

Use Date() instead of Now().