topic formating date in QlikView

formating date

souadouert — Tue, 17 Apr 2018 08:38:13 GMT

Hello

I have probleme with formating daate function, So i used this function to return the last day in month

LET ENDMONTH = date#(MonthEnd(date#('23052018','DDMMYYYY')),'MMDDYYYY');

and i want to this function return 31052018 But this statement return 05\31\2018

jaumecf23 — Tue, 17 Apr 2018 08:41:22 GMT

try this : =date(MonthEnd(date#('23052018','DDMMYYYY')),'DDMMYYYY')

souadouert — Tue, 17 Apr 2018 08:44:22 GMT

thank you

sasiparupudi1 — Tue, 17 Apr 2018 08:45:40 GMT

ET ENDMONTH = Date(MonthEnd(date#('23052018','DDMMYYYY')),'MMDDYYYY')