Max Date need to create based on data column

[Chinnu3]

Hi All,

1.I want to create a 'Max Date' column which is based on 'Created Date' column in Data load editor.

2.I want to use this 'Created Date' Column in set expression to get only  the value of "Max Date"

If I have 10-06-2022, 15-06-2022, 20-06-2022

example:- Count({<Max date(Created Date)>} Numbers)

Please give me proper expression in both 1 & 2 cases

Thanks in Advance.

[AlzhanNurtaza]

Hi!  

1. You can left join the same table with maxDate

T1:
load * inline 
[
Id, Name, Created, Numbers
1, John, 2022-01-12,23
2, Amanda, 2021-02-21,12
3, Jason, 2022-06-06,1
4, Emma, 2020-04-28,5
];

left join 
Load 
max(Created) as Created, //Key field
1 as isMax, //some flag for max date
date(max(Created)) as Maxdate 
Resident T1;

2. 

- count({<isMax={1}>} Id) or 

- count({<Created={"$(=date(max(Created)))"}>}Id)