date field relationships

[jaygamel]

This is driving me berserk and I know it's simple. But I don't get it. I'm including my db. I need to get the reminder, end and grace dates. I got the numbers. But for some reason, I can't do the date lookups/calculations/what the ((&*T&*^*.)

Any help would be truly appreciated

Jay Gamel

issueNumbers.zip

[Raybaudi]

Hi

Your calc for date_end is:

Case(

no_end = no_issue , date_start

)

BUT

no_end = no_issue

WHEN this will be valid ?

( since you stated that no_end must be: no_issue + 21 ; this is like to say that: 21 = 0 )

[jaygamel]

Sorry for the delay.

I define no_end as no_current_issue+21 (in issueabsolute). then I want to use that result (say, "236", to find the date of issue 236.

And your English is better than my Filemaker ... :

Jay

[Raybaudi]

And your English is better than my Filemaker ...

Thanks, but I didn't understand what you said...

Where is no_current_issue ?

Let me make an example:

no_current_issue...date_current_issue...no_end

.......215.............09/16/2008.........236

what is the result that you want ?

or post more examples.

[jaygamel]

I want to know the publication date of issue number 236.

jay