Find last day of current month

[ibiubu]

I would like to have a script insert a date into a field, and have that date be the last day of the current month. So for example, if the script was run in January of 2005, it would insert 1/31/2005 into the field.

Any ideas of how to do this?

And conversly, is there a script that would insert a date that would represent the first day of the current month?

Larry

[Lee Smith]

try:

Insert Calculated Result [select,

[-Queue-]

For 6 you need to make sure you're on a layout that contains the date field. Then use Lee's calc, but change Get to Status, for the last day of the month. For the first day of the month, use Date( Month(Status(CurrentDate)), 1, Year(Status(CurrentDate)) ).

[Lee Smith]

Ah Sh*t, I missed the v6, in the post and even went through the effort to change Status to Get.

Lee

[Ugo DI LUCA]

Lol...so much efforts

[-Queue-]

It's okay, Lee. *I* knew what you meant.

[ibiubu]

Thanks for the help.

LR