>>m.ldDate = {any date)
>>? gomonth(m.ldDate-day(m.ldDate)+1,1)-1
>>
>>Basically:
>>
>>1) go to the first day of the current month
>>2) advance a month
>>3) backup 1 day
>
>Can somebody, Pls tell me which one of all these methods is correct & best...
Vinod,
Either of these will work, the first one is a bit faster than the second one.
gomonth(m.ldDate-day(m.ldDate)+1,1)-1
or
GoMonth(ldDate,1)-day(gomonth(ldDate,1)