Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created DateFrom and DateTo variables to default the range of dates displayed in the calendar pickers based on today's date. I still wanted the end user to be able to change that date. In one app it works as expected and in another, with the same code it does not.
Any thoughts.
Calendar:
load
Date(SalesPriorMthEndDt + 1) as SalesMthStartDt,
SalesMthEndDt
FROM
[..\..\ExtractQVD\Calendar\SalesCalendar.qvd]
(qvd)
where DayID = Today();
LET DateFrom = PEEK('SalesMthStartDt');
LET DateTo = PEEK('SalesMthEndDt');
DROP Table Calendar;
The app that does not allow a calendar change only gives me the year 1899 and 1900 option.

Thanks for any help.
use max and min functions to get the maxdate and mindate in two fields and then use peek function to get the values into the variables. that should resolve your issue.
use max and min functions to get the maxdate and mindate in two fields and then use peek function to get the values into the variables. that should resolve your issue.
Tres, thank you.
I had just realized that on this particular app it defaulted in a Min = 0 and a Max = 10 but not on the other apps.
I removed that and it worked as the others.