Which qlik function should use to convert SWITCHOFFSET in qliksense

[rupaliqlik]

Hi Folks,

I want to convert sql script into qliksense.

but below function is date function in scql.Which date frunction I shoul duse to convert it into qliksense.

SQL: SWITCHOFFSET(g.CreatedDate, '+05:30')

Please help me to understand this.

Thanks,

Rupali M

#Scripting

#SQL To Qlik

[Miguel_Angel_Baeyens]

This is the function you are after, ConvertToLocalTime(): https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFun...