Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

getting month & year from date

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

1 Solution

Accepted Solutions
rajkumarb
Creator II
Creator II

HI PR

USE THIS FORMAT   TO Interpret

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

TO Interpret the date format first;

View solution in original post

1 Reply
rajkumarb
Creator II
Creator II

HI PR

USE THIS FORMAT   TO Interpret

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

TO Interpret the date format first;