Select all dates within past year.

[#1]

Hi,

I am having trouble selecting dates from a field that are from within the past year. I want to select all dates from my "myDate" field that are within the past year with the click of a button. I am able to accomplish similar functionality for a field with integer values. I've attached an example of my problem.

Any help will be greatly appreciated.

Thanks,

Ryan

[#2 · Accepted solution]

Hi Ryan,

You don't need an input box. Attached with answer. Please look at the trigger expression in the button.

Thanks

AJ

[MK_QSL]

Please check enclosed file which will help you to select between two dates...

UPDATE : for your application, you can use as below...

='>='&Timestamp('$(vRollingMonth)')

For MaxDate until today...

='>='&Timestamp('$(vRollingMonth)')&'<='&Timestamp(Today())

[#4]

Thanks, works like a charm.

[#5]

Many thanks -- works like a charm.