Find Current Month

[Koonce]

I need a script to find all the dates within a current month?

I have a end date to a subscription. I would like to pull all the dates that end up in that month.

Example. End Date 8/2/06 I need all the dates that are in the same month.

I need it to be dynamic. So if I am in the 10th month then it would need to find that.

I guess it is base on Today function.

Thanks for the help in advance.

[comment]

Try:

Enter Find Mode [ ]

Set Field [ yourTable::Datefield; Let ( t = Get (CurrentDate) ; Date ( Month(t) ; 1 ; Year(t) ) & ".." & Date ( Month(t) + 1 ; 0 ; Year(t) ) ) ]

Perform Find [ ]

BTW, there is no Today function in version 7 and up.