Last Day of Month

[Fred in Thailand]

I have two fields Startdate and endate.

They are used to display all records for the current month.

A script sets the fields. the start date is a no brainer but I am having a little trouble with calculating the last day of the current month. I have done it for another script that shows the current week with no trouble.

Thanks in advance for the help again

[fabriceN]

Date ( month ( StartDate ) + 1 ; 0 ; year ( StartDate ))

[Fred in Thailand]

Thanks

Someday I will know all this LOL :jester: