Solved: Get the data for the current month

[kbsudhir]

Hi All,

I have a table where there is a date field. Hre date is saved in "mm/dd/yyyy" format.

Now I have to create a query to get the data for the current month.

Please guide me how to go about this.
:doh: :doh:

Thanks
Sudhir

[OBP]

Set a new Column Heading to

month:format([datefieldname],"m")

Where datefieldname is the actual name of your datae field and in it's Criteria Row enter

format(Date(), "m")

[kbsudhir]

Thanks OBP