topic Max date in App Development

Max date

tsachdev421 — Tue, 19 Apr 2022 06:55:21 GMT

I want to update all the rows in date column with Max date

Re: Max date

durgesh22 — Tue, 19 Apr 2022 07:20:24 GMT

try below code

Temp1:

load * Inline [
Name, Date
John,
Kim,19/02/2021
Rick,
Marin,
Oscar,12/02/2021
];
NoConcatenate
Temp2:
load Date(Max(Date#(Date,'DD/MM/YYYY')),'MM/DD/YYYY') as NDate Resident Temp1 ;
//drop Table Temp1;
let maxdt=peek('NDate',0,'Temp2');
trace $(maxdt);
Final:
load Name,'$(maxdt)' as Date11 Resident Temp1;
drop Table Temp1,Temp2;

Thanks

Re: Max date

durgesh22 — Tue, 19 Apr 2022 07:24:55 GMT

if you are trying to achieve this in Table chart then try below.

Date(Max(total Date#(Date,'DD/MM/YYYY')),'DD/MM/YYYY')

Re: Max date

tsachdev421 — Tue, 19 Apr 2022 07:36:11 GMT

This is not working. Giving null in all the rows.

Re: Max date

Aditya_Chitale — Tue, 19 Apr 2022 07:45:19 GMT

@tsachdev421

Try this:

test1:

LOAD
Name,
Date("Date",'DD/MM/YYYY') as Date2,
'1' as Flag
FROM [...]

left join (test1)

test2:

load
Flag,
max(Date(Date2,'DD/MM/YYYY')) as Date
Resident test1
group by Flag;

Drop field Date2 from test1;

Regards,

Aditya

Re: Max date

vinieme12 — Tue, 19 Apr 2022 07:59:41 GMT

temp:

load Name,Date#(Date,'DD/MM/YYYY') as DateCol Inline [
Name,Date
John,
Kim,19/02/2021
Rick,
Marin,
Oscar,12/02/2021
];

left join(temp)
LOAD
date(max(FieldValue('DateCol', recno()))) as maxdate
AUTOGENERATE FieldValueCount('DateCol');

drop field DateCol;
rename field maxdate to DateCol;

exit Script;