How can I determine how many months, weeks and days have elapsed between two dates?

This could probably stand some more rigorous testing, and there is certainly scope to tidy up the output (ie remove "0 months" substrings), but I think it gets you most of the way there.

This could probably stand some more rigorous testing, and there is certainly scope to tidy up the output (ie remove "0 months" substrings), but I think it gets you most of the way there... CREATE PROCEDURE informix. Datediff(d1 DATE, d2 DATE) RETURNING VARCHAR(255); DEFINE yrcount, mthcount, wkcount, daycount INTEGER; DEFINE dx DATE; LET mthcount = ((YEAR(d2) - YEAR(d1)) * 12) + MONTH(d2) - MONTH(d1); IF DAY(d1).

Great for an SPL, but the feature needs to be accomplished within ISQL's Perform screen instructions section. – Frank Computer Jun 21 '10 at 1:46 1 It is probably 15 years since I last played with ISQL, ACE and Perform, and I've never used SE. But would it be possible to link the Perform screen to a VIEW of your table that includes this as a virtual column?

– RET Jun 21 '10 at 2:39 Perhaps with IDS.. It's probably best to create and call a cfunc 'cymwd(start_date,end_date)' to return: centuries, years, months, weeks, days and pf_putval with ESQL/C. – Frank Computer Jun 23 '10 at 19:36 VIEWS can be created in SE, however you cannot display more than one table within the same screen when declaring the viewed table in the tables section of the perform source code. – Frank Computer Jun 23 '10 at 20:32.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.