Covert Datetime to date only for calculations

D

Dave

I want to crosstab a datetime stamp field based on date only.

How do I convert a datetime to a date only? I know that I can format to be
seen that way, but that will not calculate the necessary end result.

Thanks
 
A

Allen Browne

In the Field row, if your field is named SaleDate, replace it with:
DateValue([SaleDate])
 
Top