Covert Datetime to date only for calculations

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
In the Field row, if your field is named SaleDate, replace it with:
DateValue([SaleDate])
 
Back
Top