Lets Simplify the question

[mentairia]

OK I have

START_DATE (1-25-2005)

END_DATE (7-25-2005)

From the start Date I need 2 pieces of data.

Start month in word format. The months field it is going into is a value list already with january thru December.

Start year is just a edit field I need it to take the year and insert it here.

Then I need to know the number of months between the START_DATE and the END_DATE. With this information I need it to mark checkboxes. The checkboxes are numered 1 to 12. Based on the difference between the the month I need it to check that number of boxes.

Thanks

Tony D.

[sbg2]

Example attached, I assumed the difference between the start and end dates would never be greater than 12 as you stated in another thread.

Basic:

Start Month Name = MonthName(StartDate)

Start Year = Year(StartDate)

Number of Months =

If(

Month ( EndDate ) - Month (StartDate) > 0;

Month ( EndDate ) - Month (StartDate);

12 + (Month ( EndDate ) - Month (StartDate))

)

StartDate.zip

[comment]

I'd suggest you simplify some more, specially the purpose. It is not clear to me what is your REAL DATA, and what is for DISPLAY only.

It seems like START_DATE and END_DATE your real data, and your only real data. If so, StartYear would be given by START_DATE.

But then you say:

Start year is just a edit field I need it to take the year and insert it here.

That I cannot understand.

It seems like the checkboxes are for display only - IMHO, a repeating field with Month/Year (| Jan 05 | Feb 05 | Mar 05 |... ) would better serve this purpose.

Also note that "the number of months between the START_DATE and the END_DATE" is open to interpretation. According to sbg2, for example, a whole month has elapsed between Jan 31 and Feb 1. Others might say that a month elapses when day of month is equal to to the day of starting month. Which then begs the question of Mar 31 vs. Apr 30.

[sbg2]

Also note that "the number of months between the START_DATE and the END_DATE" is open to interpretation. According to sbg2, for example, a whole month has elapsed between Jan 31 and Feb 1. Others might say that a month elapses when day of month is equal to to the day of starting month. Which then begs the question of Mar 31 vs. Apr 30.

Yes I am assuming from mentaria's previous posts that he is tracking Ad sales by month so the difference between Jan 31 and Feb 1 would be 1 month, ie. an Ad would run in both Jan and Feb.

[comment]

<> I am not arguing about the validity of the assumption. I am just pointing out that some assumption has to be made.

[mentairia]

Thanks for the feedback I am sorry I am no always clear I am italian and english is my second language I really try hard though.

Will try even harder guess I will hand write it first to make sure my brother 100% american can read it if so then I post.

Sorry again

Anthony M. Decavalcante

[mentairia]

You are dead on target SBG. That is exactly what I needed you are the Bomb.

Thanks

Tony D.

[comment]

No offense, but I don't think this is a language problem. Seems more like an organizing problem.

If you would organize what you know about your solution into three categories:

1. the data that the user knows (input);

2. the data that the user needs to know (output);

3. the way to present the data (display),

things would be much easier to understand. I believe not only for me, but for you as well.