Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
hic
I am Using date picker in my app,
I tried to disable dates using min date and max date, but dates are not disabling.
I used below expression:
<wi-datepicker bind-qs-var="vEndDate" popup="true" default="vMaxDate" min-date="vMinDate" max-date="vMaxDate">
</wi-datepicker>
variables and load script:
CalendarTemp:
LOAD
Max(CanonicalDate) AS DateMax,
Min(CanonicalDate) AS DateMin
RESIDENT CalendarMaster;
LET vMaxDate = FieldValue('DateMax', 1);
LET vMinDate = FieldValue('DateMin', 1) -1; // Needed to control the minum date autogenerated in Sales table is included in the MasterCalendar
DROP TABLE CalendarTemp;
let vStartDate = Date('$(vMinDate)');
let vEndDate = Date('$(vMaxDate)');
let vYesterday = date(vMaxDate)-1;
Thanks,
Pramod
date(date(max(Date),'YYYY-MM-DD') - date(Date,'YYYY-MM-DD'),'YYYY-MM-DD')
Max(date) means highest date in db
for example: for today max(date) is 12-8-2015, all the dates after today should be disabled.
Same way min(date) the lowest date in the DB
for example: if last date in DB is 08-08-2014 then all the dates before this date must be disabled.
hi pramod,
Can u please share me Qwidget Date Picker zip file . i want to use same in my one application .
please can u send me on my email id : brijeshm19@gmail.com
Thanks in Advanced.
Hi Pramodgc3,
Can you forward the qWidget zip file to me as well?
Thanks,
Sangram
you can download from below link;
Hi Promod,
Access to that document is denied. Can you please forward it to my mail?
Thanks,
Sangram
Hi Promod,
Thanks for Your reply .. But i am Getting Access denied error