var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: crosstab query with a datetime field
I need to create a crosstab query which will be filtered by date only (not datetime). How can I get access to only see the date (not time) in my query?
Last edited by MStef-ZG; 09-20-07 at 05:02.
The following function will "remove" the time value of a given date.
dateadd(dd,0, datediff(dd,0,[Enter Date]))
In query criteria put; Like[Enter date] & "*"
I don't believe that will work MStef.