Recent content by HugoBerg

That gets the work done: ... AND E.SERVICE_INTERVALS <= (CASE when (datepart(dd,A.ACCRUAL_PROC_DT)<datepart(dd,D.SERVICE_DT)) then(datediff(mm,D.SERVICE_DT,A.ACCRUAL_PROC_DT)-1) else(datediff (mm, D.SERVICE_DT, A.ACCRUAL_PROC_DT)) end)

Good morning group, I need to get months differences but with days precision. Let's say we have an employee with a Service Date of May 21 1999, if my reference date is May 8 2004, I need to return a value of 59 months. Only when I'll reach the date of May 21 2004 should I get a value of 60...

browsing through the forum I saw that you may indeed use recursive select with DB2: thread220-479915 Haven't tried it myself, but I will sure do soon.

I did try the email workaround but it didn't work. As for the backup option, well let's just say the energy and time involved in such a request lead me towards rewritting the thing! That would'nt be such an effort because if I open the file as a .rtf I get my raw text. I have to redo all my...

Pretty extreme case. I have a Word 97 file, let's call it Big_picture.doc, documenting a mail merge process. Being a nice a guy, I inserted the main merge document in Big_picture.doc to show the expected result. Now, Word crashes when I try to open Big_picture.doc. I get the feeling it crashes...

I'm not sure I get your need right but let me get a shot at it. I just worked on a panel this week where I wanted to prompt on the COMPANY field of a custom record (N_COMP_FUS_TBL). If a row already exists for that company, prompt on it, else I want it to prompt on a view of available companies...