topic Re: previous date in App Development

previous date

shravanveer — Tue, 14 Jun 2022 08:02:48 GMT

hi,

IF(IsNull(DATE), Previous(DATE), DATE) AS DATE it has been working for one empty field ,and i need same script for more empty fileds on the same table like shown table

ID	DATE
100	12-06-2022
101	13-06-2022
102
103	15-06-2022
104
105
106	19-06-2022

Re: previous date

abhijitnalekar — Tue, 14 Jun 2022 14:01:29 GMT

Hi @shravanveer,

Please use below script

load*,
if(
len(trim(DATE))>0,DATE,
if(len(trim(DATE))=0 and len(peek(DATE))=0,
previous(Previous(DATE)),peek(DATE)
))as Datenew,

;

load *inline
[
ID,DATE
100,12-06-2022
101,13-06-2022
102,
103,15-06-2022
104,
105,
106,19-06-2022
];