Page 1 of 1
End of Month
Posted: Fri May 30, 2003 4:18 pm
by 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.
=> RE: End of Month
Posted: Fri May 30, 2003 7:04 pm
by 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