Change Date Format to MM-YYYY in Qlik Sense

date(floor(alt(timestamp#(Open Date,'DD/MM/YYYY hh:mm),timestamp#(Open Date,'DD/MM/YYYY hh:mm:ss)),'MM-YYYY')

OR

TIMESTAMP(alt(timestamp#(Open Date,'DD/MM/YYYY hh:mm),timestamp#(Open Date,'DD/MM/YYYY hh:mm:ss)),'MM-YYYY')

Hi!

Try use Date(DateField, 'MM-YYYY')

Hi! Try this line in the load script:

Timestamp(Timestamp#([Open Date], 'DD/MM/YY hh:mm:ss') ,'MM-YYYY') AS [Open Date]