Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

belias1980
New Contributor II

Date Format not being recognized

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,

Tags (1)
2 Replies
CarlosAMonroy
Contributor III

Re: Date Format not being recognized

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

belias1980
New Contributor II

Re: Date Format not being recognized

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

Community Browser