RE: Last Date of previous month

Posted in 2003

David Buchholz — Mon, 10 Nov 2003 11:55:44 -0700 — source: Usenet: comp.databases.informix

Navdeep, How about: select DATE(DATE(extend(TODAY, YEAR TO MONTH)) - 1 UNITS DAY) from systables where tabid = 1; -Dave David Buchholz Sr. DBA Vital Processing Systems -----Original Message----- From: navdeep virk [mailto:nvirk@msn.com] Sent: Monday, November 10, 2003 8:31 AM To: rkusenet@sympatico.ca; informix-list@iiug.org Subject: Last Date of previous month List , I want to obtain the Last Date of previous Month ie 09/30/2003 ,if report is run in Oct . and 10/31/2003 when report is run in Nov. I need a Sql solution as I will be using an ACE report . --Message for rkusenet -Ravi , you email Id please ,send it to this address . TIA Navdeep _________________________________________________________________ Concerned that messages may bounce because your Hotmail account is over limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es sending to informix-list sending to informix-list