Jump to content

Find Current Month


This topic is 6450 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6450 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.