Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a master calendar table with the entire date range, but when I try to select a date range, I get the message "No data available for the selected range".
After some digging it looks like date format issue, but tried all possible combinations and it still doesn't filter correctly the dates you selected.
Attached screenshot in case it helps.
Can somebody help me?
Thank you
Your master calendar is linked or unlinked ? and if it is possible please share the expression.
is it possible for you to share your master calendar scrip ?
it might be possible that your dates are no generated .
Thanks for the responses, I'll try to answer both of them:
The master calendar table is linked to the table that I require to filter the data on.
The expression is: date(CalendarDate,'D/M/YYYY').
The script is:
MinMaxDate:
load
Min(StartDateScheduleSubject) as MinDate,
mAX(GR_EndDateScheduleSubject) as MaxDate
resident TSubjectsDatesAddendums;
Let vMinDate = peek('MinDate',-1,'MinMaxDate') -1 ;
Let vMaxDate = peek('MaxDate',-1,'MinMaxDate') ;
DropTables MinMaxDate ;
dates:
Load *,
Year(Date) & '/' & Month(Date) as monthyear,
Year(Date) as Year,
Month(Date) as Month;
// Day(Date) as Day;
Load Date($(vMinDate) + recno()) as Date
autogenerate $(vMaxDate) - $(vMinDate) ;
As your script working properly just do the slightly changes in line no: 8. add space between drop table.
I think you need to check your base data that you're getting.
hope this helpful.
There is a limit of 10000 dates in Date Picker.
Maciek