Designer analytics - date range prompt

[StephenT]

Hi all

I;'m pretty sure this is a quick fix but i can't see the solution.

i have a workflow that needs a changing date range (e.g. 13th Dec 2021 to 7th Jan 2022) then changing constantly based on the following weeks. there are several occasions when i will need to go back several months

I have added the "date" tool plus action tool and attached them both to the "filter" tool, with a date range (see blow). the Filter has a 'dummy' date range for the time being

The "Start Date" action tool has the following settings 

The "End Date" action tool has the following settings

when I run the analytics app the start/end date prompts appear correctly, but the date ranges are picked up from the filter tool, not the date prompts.

Any assistance to fix this would be greatly appreciated

I have spent several hours workin this, but can't see the solution to have this work.

[Qiu]

@StephenT 
I believe you are not configuring the Action tool correctly.

You are updating the StartDate and EndDate Columns, which is in the incoming data stream.
Instead we should update the dummy date you have set in the Filter tool as a string.

See the sample below.

[StephenT]

Thanks @Qiu 

I have updated the "action" tool for the 'startdate' column and it's now working.

But i've noticed the 'enddate' columns is still showing dates outside of the selected date

Filter range: 2021-01-01 to 2022-13-31

Start Date column: 2021-12-13
End Date Column: 2022-01-07

Based on the start and end columns i should see 48 records, but the date is showing far beyond the date of 2022-01-07.

Do I need to adjust the 'enddate' cumn action tool ?

[Qiu]

@StephenT 
It seems that you are comparing two columns, so the filter tool needs to be modified a bit.
Can you give a sample data set of yours?
it would be much easier for me to take a look. 

[Qiu]

@StephenT 
Thank you for providing the dataset.
I have implemented to the flow, it works just fine as a filter.

but I am wondering the "Start Date" and "End Date" columns you have mentioned since I dont see them in your provided dataset?
Let me know if you need any help.

[StephenT]

You are right - the dates ranges works as a filter, but i have a team of 4 colleagues who use the workflow twice a week - I'm trying to automate it to a small degree in case they forget to change the filter to the correct date range.

The start and end dates are based on the single "Effective Date" column in the Excel, not separate fields, unfortunately.

[StephenT]

Hi @Qiu 

Have you had any luck working out what I am doing wrong ?

I have got the filter configured correctly, but when I run the app the date prompts seem to bypass the date-range popup and go straight to the filter, and use those dates

the "Action" tool looks correct, but i just noticed the "Mode - value" option displays as "Simple", not "custom - does this affect the app ?

Note : 'Effective Date' has been changed to 'Hire Date'

[StephenT]

Hi @Qiu 

any ideas on thought on what is going on ?

I have followed your suggestions, as well as done a few searches which repeated what you suggested, but i can't seem to get the dat prompt working properly.

Once I get this working with your help I have several other workflows I'd like to add the date prompt to 😁