Date and Time

[CesarAustin]

For some reason I just can’t figure this out.. in my raw data I have date and time in one column… example: 3/1/2011 1:31:26 AM I also have a template table I created to add more information to that date.

tblTemp
Date QWK_Num WK_Num
3/1/2011 5 6

Want I need to do is pull across my temp “QWK_Num” and “WK_Num” by the date to my raw data but I can’t do it because of the time.. and I can’t remember how to take the time off the raw data.. I changed it from long date to short date but it didn’t work.. the time is still in the background..

So, how do I change the raw Date and Time to just Date NO TIME…

Any help would be fantastic..

Thank You.
CesarAustin

 

[boblarson]

In the query you create a new field (just in the query) to limit by:

MyNewField:DateValue([OriginalFieldNameHere])

and then you can use the criteria on that for the date.

 

[CesarAustin]

Perfect.. thank you sir…