build 'date' to use in between clause from 2 separate fields..

N

nycdon

I'm trying to parameterize reports to run with start/end dates. My problem
(or so i think) is that the final qeuries that feed reports bring in date
data as separate mm and yy fields. If I merged the mm and yy fields, can I
do a date compare (using 'between' clause) with mm-yy..i'm assuming I need to
create/mock a dd field..
thanks,
don
 
K

Klatuu

I don't know exactly how you are using this, but here are two formulas that
may help:
Returns the first day of a month:
dateserial(year(date),Month(date),1)
For today, it will return 8/1/2006

Returns the last day of a month:
dateserial(year(date),Month(date) + 1,0)
For today, it will return 8/31/2006
 
Top