qlikview Load script covert dd/mm/yyyy hh:mm:ss to yyyymm

[DestinedTale]

Hi,

I have searched through everywhere and tried all expression. But couldn't get the result.

I am working it in load script. There are also multiple values of the timestamp field. 

So i want to load the format from dd/mm/yyyy hh:mm:ss to yyyymm at load script. 

I need help to have an existing field example 29/04/2022 04:55:10 to 202204. 

[MarcoWedel]

Date(MonthStart(Timestamp#(YourTimestampField,'DD/MM/YYYY hh:mm:ss')),'YYYYMM') as YearMonth