Koonce Posted August 1, 2006 Share Posted August 1, 2006 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 More sharing options...
comment Posted August 1, 2006 Share Posted August 1, 2006 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now