Thanks a lot, George.
>>Hi all,
>>
>>I've been doing some maintenance for our FPD app and needed an equivalent QUARTER() function. I was hoping that someone can share their user-defined function if they have one.
>>
>>Thanks in advance.
>
>Using the normal calendar rather than a fiscal one.
FUNCTION Quarter
>
>PARAMETER tdDate
>
>PRIVATE m.result
>m.result = CEILING(MONTH(tdDate) / 4)
>IF MONTH(tdDate) % 4 = 0
> m.result = m.result + 1
>ENDIF
>RETURN m.result
ramil
~~ learning to stand still