Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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;