ADJUSTTIMZONE function does it convert day light savings time automatically when populating the output.

=FROMDATETIME(ADJUSTTIMEZONE ( Date:Record:input, "America/Los_Angeles" , "{CCYY-MM-DD HH24:MM}"))

Input = 2026-05-01 20:02

Current output = 2026-05-01 06:32

Expected output = 2026-05-01 07:32 

Any insights on this is much appreciated or is there any way to achieve with day light saving timings.

Thanks 

Samba

Yes, that is a documented limitation of the ITX date adjustment functions. When working on those functions several years ago we collaborated with two of our world-wide logistics customers and determined that the  ever evolving/changing rules for determining DST adjustments really required an outside (REST API) call to a utility outside of ITX. From a practical implementation perspective it was agreed that users would want to call their choice of such open-source APIs from ITX when they were needed.