4GL DateTime Variables

Posted in 1991

Walt Hultgren {rmy} — Wed, 13 Nov 91 14:40:40 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!wupost!sdd.hp.com!hp-cv!hp-pcd!hpspkla!engstrom From: engstrom@hpspkla.spk.hp.com (Kathleen Engstrom) Newsgroups: comp.databases.informix Message-ID: <20490001@hpspkla.spk.hp.com> Date: 13 Nov 91 15:46:15 GMT Organization: Hewlett Packard Company, Spokane, Wa. Hi I'm fairly new to the world of I4GL programming. I'm trying to format some datetime variables. I was able to use expand to break it up and get just the date portion of the variable, but I haven't found anything that will allow me to format the result. (This is in a report) I would like to put the date in a more human readable form. (i.e. 11/7/91 instead of 91-11-7). My second question: I would like to calculate the difference in two dates and then subtract out weekends and holidays from the result. I would appreciate any pointers, suggestions on how to do that cleanly. A turnkey application would be even better :-) Thanks in advance Kathleen