Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
wgoudeau
Contributor II
Contributor II

Date Time conversion help (source SQL)

Hello,

 

I am pulling data from a SQL server and having issues with my date. I would like Day, Month, Month Year and Year pulled out as separate fields. I tried with Month Year first. If anything a master calendar? The Chart below is showing days when I thought it would show month year?

 

[table1]:
LOAD
.....
// [date_started],
Date(MonthStart(Date#(SubField([date_started], ' ', 1), 'YYYY-MM-DD')), 'MMM YYYY') as MonthYear,

....

SELECT "audit_id",
....
"date_started",

FROM .....

 

 

wgoudeau_0-1644856952636.png

 

Original date time before I tried to convert it :

 

wgoudeau_1-1644856995999.png

 

 

 

Labels (5)
0 Replies