N
NetworkTrade
This works in a query design view column:
WeekOf:
IIf((Weekday([Date])=1),([Date]-6),(DateAdd("d",-(Weekday([DATE])-2),[DATE])))
It looks at the date field and assigns it to the 'WeekOf' which is always
the preceeding Monday.
But in the next query I apply a Criteria to the WeekOf field to range it
between date start and date end fields that exist in a form. The form format
is definitely date. But I get a data mismatch error when I attempt to apply
the criteria.
It leads me to believe that my manipulation of the date with the Iif has
changed its status to not being recognized as a date.
Would welcome advice.
WeekOf:
IIf((Weekday([Date])=1),([Date]-6),(DateAdd("d",-(Weekday([DATE])-2),[DATE])))
It looks at the date field and assigns it to the 'WeekOf' which is always
the preceeding Monday.
But in the next query I apply a Criteria to the WeekOf field to range it
between date start and date end fields that exist in a form. The form format
is definitely date. But I get a data mismatch error when I attempt to apply
the criteria.
It leads me to believe that my manipulation of the date with the Iif has
changed its status to not being recognized as a date.
Would welcome advice.