In QuikReports for AccPac Plus (001213)
When I use the LastYearYTD function in the Selection formula IE (??? < LastYearYTD)it doesn't select any records, but if I put 12/07/2000 in the formula it does work.
The report has not been changed and it used to work. Is this some latent Y2K bug?
Am I using it incorrectly?
Thanks
Scott

Hi Scott,

The available date ranges in Quik Reports are used in a specific way. For example, if you want to select all the records with a Date in the Last Year YTD range, the syntax would be:

Date in LastYearYTD

What the pre-defined date ranges do is use the system date to calculate what the starting and ending dates of the range are. LastYearYTD is not a value you can compare to, and this is why you can't use the comaprison symbols =,< or >.

'in' is used for arrays. You could also have the syntax "Date in (Date(2000,01,01) to Date(2000,12,07))" to do the same thing, but since this formula is hardcoded, it would have to be changed every day. This is the reason for the pre-defined date ranges, which are really date 'arrays'.

The syntax Date < LastYearYTD is not correct, and I'm surprised this ever worked even once. If you make the change of replacing '<' with 'in', you should get better results.

If the syntax you really want is any date prior to today's date last year (ie Dec 7, 2000), then what you need is quite different. To do this:

Invoice Date < Date(Year(Today)-1,Month(Today),Day(Today))

where you replace the Invoice Date field with the date field you really want.

Regards,
Softrak Support