Identifying Max date in Alteryx

[Bharath]

Hi,

I need to identify maximum date how to to identify max date in Alteryx ?

Thanks,

Barath

[MarqueeCrew · Accepted solution]

SUMMARIZE TOOL

Max(Date)

You can take that date and APPEND FIELDS to put it on every record.  Then you could use it in a formula or filter:

IF 

[Transaction Date] == [MAX_DATE] THEN 'Hotline'

ELSE [Customer Segment]

ENDIF

That was just an example of how you might use it.

Cheers,

Mark

[Bharath]

Hi Mark,

I am able to get max date by using the Summarize tool. thank you for helping me on this.

[Azhar1]

Hi Mark,

Is there a way to find max date by month? I have a data set with a row for almost every day in each month. I want to be able to find the max date for each month and then use that in an if statement. I have tried using "DateTimeTrim([Date],'lastofmonth')" formula but this adds the last day for each month which is not always the case in my data set.

Thanks.

[jmt214]

@Azhar1 

You can add a formula tool creating fields for both year and month, and then use a summarize tool to group by those new fields and do a max of your original date field.

[Azhar1]

@jmt214 

Thanks a lot. This worked perfectly to pull out the max date for each month in my data.

[Alfredo_Diniz]

Excellent tip!

Thanks!