Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date field issue in excel

Hi

I have a data in excel and I want to append the date field to my calendar. well in excel some date appears as character string and my challenge is even after using many date functions i have gotten the desired result.

Please Help.

2 Replies
Anonymous
Not applicable
Author

Try using the Date#() function to tell QlikView how to interpret the strings as proper dates.

Besides that it's hard to help since we don't know what your date format looks like.

Anonymous
Not applicable
Author

date error.PNG

This is when I use the Date#() function