Jump to content

Constrain data using a date range


Wayne0412
 Share

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

Recommended Posts

Hello,

Can someone please please please help me. If I had hair I would be pulling it out right about now!!!

I have a succesfuly written a script which constrains a set of data to one particular order type IE: Quote from four possible order types (Quote, Invoiced, Reservation and Hold). That part was easy.

Now I want to further constrain that list to those orders that fall within a date range, specifically from Today's date to Today's date plus seven, basically omitting records which fall outside that date range.

I need to be able to do this from within a script, with no user input, and without dialogue.

Essentially what I am trying to do is produce six different reports from one set of master data and have the user press one button to populate and sort all of the reports.

If I could get this date range thing sorted, the rest of the reports would be easy to do.

Please help, I am desparate!!

Cheers

Link to comment
Share on other sites

Try:

Enter Find Mode []

Set Field [ YourTable::Datefield ; Get (CurrentDate) & "…" & Get (CurrentDate) + 7 ]

Constrain Found Set []

Brilliant, works like a dream, thank you so much.

I spent about six hours trying to get that to work!!!

Link to comment
Share on other sites

This topic is 4363 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
 Share

×
×
  • Create New...

Important Information

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