Selecting a range of data

[Mr.Tom]

Apologies for my lack of experience!

What I want to do is the following but I'm darned if I can figure out how to get FM to do it!

If 'Date A' is between 'Start Date' and 'End Date' then list all values of 'Field A' between 'Start Date' and 'End Date'

I'd then like to be able to export 'Field A' as text but that's a different story..

What is the best format to have the date in for this kind of thing?

Thanks

[QuinTech]

Hi, Mr.Tom. You could make a calc date field equal to:

Case ( Start Date < Date A and Date A < End Date , Field A )

The result of this calc for each record will be the value of Field A iff the date is within the range. If you wanted to display all of those on the same record, a portal is probably your best bet.

If you export that field, it should come out as a "normal-looking" date. Are you trying to export it with months spelled out?

HTH,

Jerry

[Mr.Tom]

Hi Jerry,

Thanks for that. I'm guessing I could have more than one field by just having Field A, Field B, Field C etc

It would be good to have the months in full spelling.

When setting up the calc date field, do the dates need to be of a certain form ie. all numbers?

Thanks

Tom

[QuinTech]

When setting up the calc date field, do the dates need to be of a certain form ie. all numbers?

If the original field is a date (and you won't be able to do inequality comparisons if it's not), then make the calculation a date and you should be fine.

[Joseph31]

Hi Quin,

How do you make a pop field that asks you for these dates... ie: before your report is printed?

Joseph