getting month & year from date

[#1]

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

[rajkumarb · Accepted solution]

HI PR

USE THIS FORMAT   TO Interpret

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

TO Interpret the date format first;