getting month & year from date

Mon, 26 Jan 2015 17:27:11 GMT

hi experts,

I have a Saledate in DD/MM/YYYY format. i need the fields Month & year separated from date.

i have used the following script:

DATE(Saledate , 'DD/MM/YYYY') AS DECDDT,

MONTH(Saledate ) AS MONTH,

YEAR(Saledate ) AS YEAR

but i m not getting the fields. any other suggestions plss

Re: getting month & year from date

rajkumarb — Mon, 26 Jan 2015 17:35:47 GMT

HI PR

USE THIS FORMAT TO Interpret

DATE(DATE#(Saledate ,'DD/MM/YYYY'),'DD-MM-YYYY') as Saledate,

TO Interpret the date format first;