Here's one I use. TODAY = OCONV(DATE(), "D4/") MO = FIELD(TODAY, "/", 1) YR = FIELD(TODAY, "/", 3) MO += 1 IF MO > 12 THEN MO = 1 YR += 1 END EOM = OCONV((ICONV(MO:"/":"1":YR) - 1), "D4/")
Charles Shaffer Senior Analyst NTN-Bower Corporation From: Wjhonson <[email protected]> To: [email protected], Date: 12/05/2011 01:03 PM Subject: [U2] End of Month date routine Sent by: [email protected] Does someone have a routine that, no matter what day you run it, returns the End of Month Date ? (Assume the end of month date, is the calendar end of month date not some screwy business date) _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users -- This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
