How to obtain a Date type with out the time attached

[George]

Good Day.

I have a field [CurrentDay] of type Date/Time. The values for this field are entered through the selection from the date picker. However the time of the day always come along with the date - even if it is not seen. This creates a huge problem when making a query based on this field because no results will be returned unless the time is included with the date in the criteria.



The other part to the problem is that I cannot find a built in function in the expression builder to generate the current date without appending the time - now() certainly does not do that - even if the time is not seen it is there.

Are they answers to these problems?

[John_G]

Try applying the Int function to the date value, e.g. Int(now()). Date values are stored as numeric real numbers, with the integer portion being the date, and the decimal portion being the time, so int(datevalue) gives you only the date.

[orange]

Further to John_G's response, you should become familiar with techonthenet, a great site for Access functions -syntax and examples.

Date Now

Good luck with your project.

[George]

Thanks John_G's it is working fine