>>Is there a quick way to find the last date in any given month. I need to select records that fall within the selected month and year. I was going to use the between() command but how can you select the last date of a month (28,30,31) without lines of code?
>

>? LastDay(DATE())      && Just day
>? LastDay(DATE(), .t.) && We want DATE
>
>
>FUNCTION LastDay(ldDate, lbDateWant)
> LOCAL ldLastDay
> ldLastDay = GOMONT(ldDate,1)-DAY(ldDate)
>RETURN IIF(lbDateWant, DAY(ldLastDay), ldLastDay)
>

Borislav,

Try with {^2006/01/30}

Since every month has a first, go back to the first of the month, add one month, subtract one day

?gomonth(m.d+1-day(m.d), 1) -1