I Think you should work with date as YEAR , MONTH and DAY.
But I think you shoul post your qvw for us to check out.
Also look at the examples below.
hope it helps.
day( date )
Day. Returns an integer representing the day when the fraction of expr is interpreted as a date according to the standard number interpretation.
Example:
day( 1971-10-30 ) returns 30.
If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation. To solve this problem, you can either change the settings or use the date# interpretation function.
week( date )
Week number. Returns an integer representing the week when the fraction of expr is interpreted as a date according to the standard number interpretation.
Example:
week( 1971-10-30 ) returns 43.
If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation. See above under day.
month( date )
Month. Returns a text string representing the month when the fraction of expr is interpreted as a date, but can be formatted as a number.
Example:
month( 1971-10-30 ) returns Oct.
If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation. See above under day.
year( date )
Year. Returns an integer representing the year when the fraction of expr is interpreted as a date according to the standard number interpretation.
Example:
year( 1971-10-30 ) returns 1971.
If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation. See above under day.
