Hi
i have table from web source
Source = Web.Page(Web.Contents("http://www.accuweather.com/en/sa/dammam/297095/january-weather/297095?monyr=1/1/2016&view=table")),
Date column showing Fri 1/1 , Sat 1/2
how can i convert into proper date (dd/mm/2016) eg. 1/1/2016, 2/2/2016
i have table from web source
Source = Web.Page(Web.Contents("http://www.accuweather.com/en/sa/dammam/297095/january-weather/297095?monyr=1/1/2016&view=table")),
Date column showing Fri 1/1 , Sat 1/2
how can i convert into proper date (dd/mm/2016) eg. 1/1/2016, 2/2/2016