Re: Find First of Month

FireGeek wrote:
> Again, Thank You everyone.
>
> I am using the following
>
> TO_CHAR(LAST_DAY(ADD_MONTHS(E.HIRE_DT, 6))+1, 'IW')
>
> This gives me the week number 6 months after the employee hire date!
> Exactly what I was looking for.

No it won't.
It will give you the week for the 1th day of the next month, following that 6 months period.
If the employee was hired at April 15th, it will *not* give you the week for October 15th but for November 1st, i.e. 6.5 months after the hire date.
If the employee was hired at April 1st, it will *not* give you the week for October 1st but for November 1st, i.e. 7 months after the hire date.

>
> THANK YOU AGAIN!!!
>

First: 90 days --> 3 - 4 months
Now: 6 months --> 6 - 7 months
Try to be more precise when stating your problem.. ;-)

-- 
Jeroen