{{formatDate(addDays(“2025-01-27T00:00:00Z”; floor((1.i - 1) / 3)); “YYYY-MM-DD”; “Asia/Kolkata”)}}T{{if((1.i - 1) % 3 = 0; “02:00:00”; if((1.i - 1) % 3 = 1; “06:00:00”; “17:00:00”))}}
Account Time Zone Set: Asia/Kolkata
formatDate : Asia/Kolkata
On iterate
File 1: → 02:00 → 07:30 AM IST
File 2: → 06:00 → 11:30 AM IST
File 3: → 17:00 → 10:30 AM IST [Error]
Why this malfunctioning?
It to be 10:30 PM as per File 1 & File 2