I want to change the date format from one form to another form

[SRI8273]

load * Inline [
ID,Date,SalesA
1 , 1@1@2022,100
2 , 2@1-2022, 100
3 , 3@1@2022, 200
4 , 4@1@2022, 100
5 , 5@1@2022, 100
]
;

i want in DD/MM/YYYY FORMAT

[Mauritz_SA]

Hi @SRI8273 

You can use:

load
ID,
Date(Date#(Replace(Date,'-','@'),'DD@MM@YYYY'),'DD/MM/YYYY') AS Date,
SalesA
Inline [
ID,Date,SalesA
1 , 1@1@2022,100
2 , 2@1-2022, 100
3 , 3@1@2022, 200
4 , 4@1@2022, 100
5 , 5@1@2022, 100
]
;

Replace is used to ensure that all values have the same format and that values such as 2@1-2022 will be seen as 2@1@2022.

Date# is used to tell Qlik what format you will be providing the date in.

Date is used to tell Qlik how you want it to format the date.

I assume that your format was DD@MM@YYYY, but if it was actually MM@DD@YYYY then you can just replace the format in green above. Hope this helps. 

[SRI8273]

THANKYOU FOR THE INPUT