Change a field type in a query????

[mkelly]

If I have a field in my table that is "NOW()" is there anyway I can change it in a query to be "DATE()"

 

[mission2java_78]

If I have a field in my table that is "NOW()" is there anyway I can change it in a query to be "DATE()"

Why do you have a field that is Now() ???

Do you default 'a' field to Now?

In your query do the following:

Blah: Format(Now(), "dd-mmm-yy")

That will give you just the date.

 

[mkelly]

I use now() to get exact times that an employee worked on a task. I need date() to pull the production report for each employee for a specific period of time.

thanks for the help!!

 

[mission2java_78]

I use now() to get exact times that an employee worked on a task. I need date() to pull the production report for each employee for a specific period of time.

thanks for the help!!

So you got a solution or not ?

 

[Shep]

In your query, you can right-click on the grey bar above the field and click Properties. The Field Properties dialog box appears. Go to Format and select Short Date.

Alternately, you can highlight the field and, from the menu, select View, then Properties.