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])
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Convert Datetime Stamp to HH and MM Worked 7
DATETIME Split 0
Parameter Query with DSum 1
How do i calculate duration between datetime values in Access? 1
Can't query datetime field formatted as m/d/yyyy 1
date confusion 2
Access pass-through query, SQL-92 combining strings: '&' does not 4
Crosstab query with multiple fields 2

Back
Top