Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Corey32
Contributor
Contributor

Date fields not showing on Sheets

My data sources have multiple date fields that have been converted from Timestamps. When I try to load those columns into a table or use those fields as filters they all show as null/empty

 

Here is the data in the Data Manager

Corey32_1-1674166896177.png

Then when I try to add Invoice Date to a sheet I get this

Corey32_2-1674166936028.png

 

Labels (2)
1 Solution

Accepted Solutions
Corey32
Contributor
Contributor
Author

Not sure why it wont show up but I was able to fix the issue. I created a calculated field first by stripping the timestamp out and converted the remaining values to a date. It shows up now.

View solution in original post

1 Reply
Corey32
Contributor
Contributor
Author

Not sure why it wont show up but I was able to fix the issue. I created a calculated field first by stripping the timestamp out and converted the remaining values to a date. It shows up now.