Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a connection to a direct view in the DB that pulls fields that is used in an application.
One of the fields is a date field.
The date field in published app shows up with the options of "Date.Calendar.Date, Date.Calendar.Month, Date.Calendar.Quarter, Week, Year, YearMonth and YearQuarter. This application is published and i cannot see the load data info, to see if they did anything additional.
I made another application that utilizes the same connection/view, however the Date field is not recognized as date and i had to do the below to just get it to be a date, but still wont come up with the options as .Month, .Week, YearMonth etc. They do not come up as options when i try to add fields..
Any recommendations on what i can do to get qlik to recognize the date field?
DATE(FLOOR(timestamp#(CurrentStatusDate,'MM/DD/YYYY')),'M/DD/YYYY') AS NEWDATE,
Month(CurrentStatusDate) as Month,
Year(CurrentStatusDate) as Year,
CurrentStatusPEDate,
DATE(FLOOR(timestamp#(CurrentStatusPEDate,'YYYY-DD-MM')),'M/D/YYYY') AS NEWPEDATE,
Month(CurrentStatusPEDate) as PEMonth,
Hi Elias,
You can try the following:
Date(Floor(CurrentStatusDate)) as NewDate,
Year(Date(Floor(CurrentStatusDate))) as Year,
Month(Date(Floor(CurrentStatusDate))) as Month
Hope that helps,
Carlos
Hi Carlos!
Thanks for the response, i used that when i go to fields and drop down, i dont see those as options...
It seems like its a built in feature that is called?
Thank you