Extract current month

[Guest]

Hi,
I'm using the below expression to extract the month and year from the
field [entrance date],how can i do the following:

* put the query criteria current month.
* Put the query criteria the past month.

The expression is:
format(datepart([Entrance Date]),"yyyy/mm")

 

[Allen Browne]

In the Field row, type this in a fresh column:
TheYear:Year([Entrance Date])

In the next column, type:
TheMonth: Month([Entrance Date])

If you want the previous month, use this instead of [Entrance Date]):
DateAdd("m", -1, [Entrance Date])

You can add criteria under these calculated fields if desired.