Day & Month & Year

[#1]

Hello all,

I've attached snapshot for order table and business intelligence plan. According to business intelligence plan how can we bring the data(Year & Month & Year) from orders date? 

I request to help in this if anyone knows.

Regards,

Sattish G

[tresesco]

Try like:

Load

          Date(OrderDate, 'MMM-YYYY') as YearMonth

or, using a proper date function like:

Load

          Monthname(OrderDate) as YearMonth

[#3]

Thanks for quick response.