YTD + LYTD button - error

[robbybalboa]

Hello,

I have created a textbox button with the following statement:

='(>='  &YearStart(Today())&  ' and <='&  date(Today())   &')

or

(>='  &YearStart(Today(),-1)&  ' and <='&   AddMonths(Today(),-12)  &')'

Result text-string:

(>=01.01.2013<=22.08.2013) or (>=01.01.2012<=22.08.2012)

This result is a parameter in a text box -->  action --> selection in field

So far so good.

Problem: Only the first part of the search criteria is used in my app.

The filter is only working for the period 01.01.2013 – 22.08.2013.

Any ideas why this solution does not work?

If I change the input to (>=01.01.2012<=22.08.2012) or (>=01.01.2013<=22.08.2013) then
the search is only possible for the period 2012.

Thank you very much

Robert

[robbybalboa]

Gratulation.

This is the solution - not to use the braces in the middle of the statement.

Thank you all for your support.

BR

Robert

[tresesco]

PFA, it's working fine.

Edit: Well, you have got the solution already, anyway, an alternative is always good.