For formatting, you just need a date function and date#()... date#() is used for interpretation (i.e. when QlikView is having a difficult time understanding that you date field is a date field. So in your case, you already have a date (in the shape of a number), so you need to use Date() function.
Also, the format doesn't have to be surrounded by square brackets
Date([Date], 'DD MMMM YYYY')
Try this ways
LOAD *, Date(NewNUM , 'DD MMMM YYYY') as NewDate;
LOAD *, Date(NumDate) as NewNUM;
LOAD * Inline
date.qvw 148.0 K