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.

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

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.

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.

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

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

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

Thanks

Tony D.

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.