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

[BRRLL99]

@binuacs @ShankerV 

Sample dates have been attached, even though excel format is in dd-mm-yyyy, in my alteryx workflow dates are in yyyy-mm-dd

Since lot of dates are repeating I would like to have updated solution -30,-60,-90 days.

ex: may-05 selected it should show all -90 days transactions, even the repeating dates.

[binuacs]

@BRRLL99 Updated the workflow

[ShankerV]

Hi @BRRLL99 

Please find the expected output.

Please modify the input file, as below with your desired source file

.

Many thanks 

Shanker V

[BRRLL99]

Hi

Since record ID is attached it is showing only 90 records

each date has multiple transactions, if -90 selected it should all -90 days and all 90 days transactions including repeated dates too

[BRRLL99]

@binuacs 

I tried your workflow. But it is showing blank

workflow has been attached please check

[binuacs]

@BRRLL99 Sorry I am away from my system, just update the workflow as mentioned in the screen shot,

only the filter tool needs to be updated.  Note that I did not use the action tool to update the date interface tool, instead I directly updated with #1

[binuacs]

@BRRLL99 For the numeric interface tool in the action tool replace 90

[ShankerV]

Hi @BRRLL99 

Please find the result for all 90 days/60 days/30 days

Including all repeated dates and also in order.

Many thanks

Shanker V

[BRRLL99]

tried still showing blank columns

[ShankerV · Accepted solution]

Hi @BRRLL99 

It is because of the Alteryx Latest version which I am using.

When I am importing the file, the below dates are automatically read in ISO format.

I assume you might be using the older version, hence the date is not auto converted to ISO format.

I recommend to insert a date time tool in-between and convert the dates please.

All the remaining remains the same.

Many thanks

Shanker V