Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello folks,
I'd like to creat a button in QV that selects all months that already passed
(for example: we are in April, I need to select Jan, Feb and Mar)
Month is the field name.
Could you people help me?
Thanks in advance
Filippo
Hi Filippo, it can vary depending how the month field is created, but this can work in some situations:
In properties of the button add an action "Select in field":
FieldName: MonthFieldName
Value: ='<=' & Num(Month(Today()))
PFA,
Yeah, exactly.
But, I want to click YTD and select from 01/jan to 31/mar, because April has not finished yet.
PFA,
Thanks man!