Identifying Max date in Alteryx

Bharath

Hi,

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

Thanks,

Barath

Date Time

Preparation

Accepted answers

MarqueeCrew

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:

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

ELSE [Customer Segment]

ENDIF

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

Cheers,

Mark

All comments

MarqueeCrew

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:

[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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280