Skip to main content
Announcements
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mrbqlik2009
Contributor III
Contributor III

pick voucher dates less thank selected date from calendar

Hi,

I have calendar contain year, month and day. and bellow that have table that for showing vouchers. each voucher has date.

I want when i selected one date from calendar, show all vouchers dates less than selected.

 

Labels (2)
1 Reply
Kushal_Chawda

Create a variable on frond end

vSelectedDate

=max(CalendarDate)

then use below expression

=sum({<CalendarDate={"<$(vSelectedDate)"}>}Value)