What date was the 1st Tuesday of last month . . .

[Chris Sharman]

>define FIRST_DAY_OF_PREVIOUS_MONTH date = &
>     (floor(date(days(lastday(sysdate)) - 32) / 100) * 100) + 01
>define FIRST_TUESDAY date = date(days(FIRST_DAY_OF_PREVIOUS_MONTH + &
>       index('106543',ascii(mod(days(FIRST_DAY_OF_PREVIOUS_MONTH),7)))))

Wow. Neat code.

Chris
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.ccagroup.co.uk/
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.