Date Fields

[Adam_RL]

Im trying to set up a date picker and vizlib calendar and I noticed my dates are formatted as yyyy/mm/dd hh:mm:ss (UTC 0). I have consumer rights in QS and how can I make changes to the dates to prepopulated data, visuals, dashboards. There was an update to the app that feeds the data and this new format is becoming somewhat of a headache. I've had to use  Year(Timestamp#(Replace([Task Create Date], ' (UTC 0)', ''), 'YYYY/MM/DD hh:mm:ss TT')) = 2025 or
Year(Timestamp#(Replace([Task Closed Date], ' (UTC 0)', ''), 'YYYY/MM/DD hh:mm:ss TT')) = 2025

What should the standard date look like in a table and is there a better expression to fix the date fields?

[Chanty4u]

Try this 

Year(Timestamp#(PurgeChar([Task Create Date], ' (UTC0)'), 'YYYY/MM/DD hh:mm:ss')) as Year

Month(Timestamp#(PurgeChar([Task Create Date], ' (UTC0)'), 'YYYY/MM/DD hh:mm:ss')) as Month

[BrunPierre]

In Qlik, dates are represented as numeric values, where the integer represents the date and the decimal represents the time. To avoid broken associations, separate the date from the time and use Floor() to keep only the date for linking and calendars.