Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
I used the script for the date in numeric format and I got my date field in DD/MM/YYYY
Date(Num#(Date)) as Date,...
but the challenge is on my chart title... I used this expression... ='Sales Figures as at max(Date)'... to get the latest date... It's showing me numbers not date
Because Max() only works on numbers, not on dates, it will always return the numerical value that underlies your date. You will have to format it into a date again, just like Marcus says.
