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.
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.
This is when I use the Date#() function
Retrieving data ...