I have a field to Display the Month and change to text format so I can use the pop-up list functiont: selection as below

January

February

March

April

May

June

July

August

September

October

November

December

one of my database function need to know how many days of a month to calculate the OverTime Salary

is anyone can tell me how should the script write?

The field store the Month call "Begin Month"

Thanks for reading this and please give me help

thanks a lot

Edited August 13, 200520 yr by Guest

The last day of the month is Date ( Month +1, 0, Year). Using Day function will then give you number of days in the month.

You can also get the last day of the month using:

theDate - Day(theDate)

Tid-bit picked up from Comment! :(

That would be the last day of the PREVIOUS month.

Ooops, hadn't had coffee yet. Of course. :blush:

Thank you very much

I have sort it out by you giving helps

Thanks again...

but I have a final problem can't figure out!!

I guess it's quite difficult to figure out

Yes, when you won't tell us what it is.

Edited August 14, 200520 yr by Guest
typo

I think it's the Butler in the Pantry. :laugh:

well actually, the database I am creating is for calculating the promoter salary, but I need to divided to two part, first part also the root part is Promoter, I can select which promoter, then when I click in to the detail layout, I can choice different month of that promoter, but I don't know how to do that....