Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

wrong year shown in calender object

m using calender object, in tht, day and month are right but getting year as '- 5877'  ?????//

my date is in QVW date format.

13 Replies
sujeetsingh
Master III
Master III

Hi try using Date () and DATE#() function and then try to get the year.

Not applicable
Author

used #, still the same result

sujeetsingh
Master III
Master III

just give a sample

Not applicable
Author

sorry cant share it but m using inputbox for the dates, which is already in date format

m doing some silly mistake

sujeetsingh
Master III
Master III

may be formatt of the date field in input box.

Not applicable
Author

hav kept it in m/d/yyyy format....

Not applicable
Author

kakey aaj ka pura din hi kharab hai......

sujeetsingh
Master III
Master III

hahah prasanth it happens some time..........Chill maro

Not applicable
Author

in 3 yrs of qvw nvr gt stuck in such a mess, chalo bye.... thnks for the help