Dateserial and datetime

[webisti]

Hi
I do have a query with with these two colums:
MAILSent that is giving a dd/mm/yyyy hh/mm/ss result and another column with Followupdate with a format dd/mm/yyyy


In a third column I do want to add expedited and I am using the formula :

EXPEDITED: IIf([MAILSENT] Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0) Or [FOLLOWUPDATE] Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0),"X","")

The results are not including all reccords especially from the mailsent, I am doing smth wrong but cannot come to what?

Any ideas?

Thanks

Webisti

[Dal Jeanis]

As long as the zero month in January doesn't cause problems, that should get you an "X" in all records where the [MAILSENT] and [FOLLOWUPDATE] fields are present and have values in the prior month. The problems I'd look for are (1) NULL dates in those fields (2) MAILSENT dates on the last day of the month - I bet MAILSENT is a timestamp, so verify that the value of DateSerial(Year(Date()),Month(Date()),0) gets you the END of the day on the monthend, not the beginning of the day.