I agree. Our visual foxpro apps are using calendar tables. This is for our old foxpro dos app that we still use.

>>Thanks a lot, George.
>
>You're welcome, Ramil. I also did some stuff with fiscal months, quarters and years in FPD/FPW. I found that the easiest (and most flexible) solution there was to create a table of months with beginning and ending dates.
>
>>>>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