YTD Button

[Anonymous]

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

[rubenmarin]

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()))

[qv_testing]

PFA,

[Anonymous]

Yeah, exactly.

But, I want to click YTD and select from 01/jan to 31/mar, because April has not finished yet.

[qv_testing · Accepted solution]

PFA,

[Anonymous]

Thanks man!