Re: Query/400 and dates

[boothm@xxxxxxx]

I couldn't answer sooner  -  my motherboard and hard drive died a
painful and agonizing death.

Thank you for the answer to this problem for us.

Actully, as near as we could find, this worked very well.  Years seemed
to be correct, even when the birthday hadn't happened yet.  One change
we made that worked was in the substring.  I have changed it here; note
the '19' and note that I removed the "digits" keyword.


Simon Coulter wrote:

> Assuming your job date format is *MDY
> 
> AGE = YEAR(CURRENT(DATE) - DATE(SUBSTR(BIRTHDT, 3 ,2) || '/' ||
>                                 SUBSTR(BIRTHDT, 5 ,2) || '/' ||'19'||
>                                 SUBSTR(BIRTHDT, 1 ,2) ) )
root
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---