Date Macro

[BRRLL99]

Hi Team,

I'm looking to build Date Macro

Let's take example if the Have selected 01-01-2023 in the date , by default the end date should be plus 90 days, only 1-1-2023 to 31-03-2023 dates should be shown 

( if possible through drop down the end date can be selected through drop down ex: 30 days, 60 days, 90 days etc...)

ex: start date : 01-01-2023 end date +30 days etc; 

if any one has worked on it please share the workflow

[BS_THE_ANALYST]

@BRRLL99 Try this that I just built. You can select the initial date from the Date Picker, then select how many days to add on. It will return the entire range of dates.

Workflow:

[BS_THE_ANALYST]

@BRRLL99 

[binuacs]

@BRRLL99 similar to @BS_THE_ANALYST approach

[BRRLL99]

@BS_THE_ANALYST @binuacs 

Hi

I have start date from 2020-01-01 to 2020-06-30,

I would like to have a macro date tool, if 2020-01-01 is selected then by default it should filter dates from 2020-01-01 + 90 days

End date should also be shown as list , but it  should not be edited

Default dates can be selected through drop down ex: 30, 60, 90 

for ex: If I select 2020-01-15 it should filter from 2020-01-15 to 2020-04-15

[binuacs]

@BRRLL99 Attaching the macro based on my understanding

[ShankerV]

Hi @BRRLL99 

Please find my solution attached.

I see this one similar to the post 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/DATE-Macro/m-p/1083789/highlight/false...

Many thanks

Shanker V

[BRRLL99]

@ShankerV @binuacs 

Slight change in the query 

If I select particular date it should be -30 or -60 days etc;

for ex: If I select 2020-04-15  filter should show till 2020-01-15 ( 90 days) {jan-15, April-15}

the dates should be in order, filter should show jan-15 to april-15

[binuacs]

@BRRLL99 updated the workflow

[ShankerV]

Hi @BRRLL99 

Please find the modified solution.

Note: -90 days comes as 17-01-2020 instead of 15-01-2020 as because we have few months in-between with 31 days.

It calculated -90 days from current date selected.