>>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())
>? LastDay(DATE(), .t.)
>
>
>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
Gregory