formating date

[souadouert]

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 · Accepted solution]

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

[souadouert]

thank you

[sasiparupudi1]

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