End of Month

[GSL]

Do you have an easy way to create calculate fileds for first of the month and end of month base on a date filed? For example: the due date is 7/15/03, the first of the month = 7/1/03 and end of the month = 7/31/03.____Thanks.

[kfleming]

[updated:LAST EDITED ON May-30-03 AT 07:05 PM (EST)]For the start of month you can use:__DATEFLD-day(DATEFLD)+1__For the last day of the month you can use:__ADDMONS(DATEFLD,1)-DAY(ADDMONS(DATEFLD,1))______Kathleen__R&R Support