This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
From the date interface tool , I am choosing a date . In the 'Action' conifg , I select 'Update Value with Formula' to
derive yearmonths ( From & To) from the date chosen .
In the In-DB filter tool , I have chosen the 'custom filter' option . The filter expression goes like year_month between 111111 and 999999 .
My requirement is , if the user selects the date 07-APR-2021 from the tool , the filter should have the value year_month between 202004 and 202103
Please note, my formula for deriving the year months from date is correct . But for some reason , the filter expression is not changing from year_month between 111111 and 999999 to year_month between 202004 and 202103.
Instead it changes to 0.00000.
Please refer the pictures attached. Appreciate your help
In your Action tool, you're using || to concatenate the strings as in 'year_month between '||DateTimeformat(Date... II is the concat symbol in Oracle but in Alteryx, || is OR. The action tool runs in an Alteryx context, so it's performing an OR on your text strings. Replace the || with + which is the concatenate operator in Alteryx