I don't have a good for you at the moment, but I see that a lot of people missunderstand the date() function. It is a formating function that presents a numeric value as a date in default or specified format. In my case 'MMMM' which is the full month name. It is important to remember that the underlying numeric value will not change when using date().
Consider this The timestamp '2021-04-25 09:57:00' it has the numeric value of 44311.414583333. The date '2021-04-25' has the numeric value of 44311. Using Date() on a timestamp will not change the underlying numeric value. So Date('2021-04-25 09:57:00') will present the string '2021-04-25', but the numeric value will still be 44311.414583333
To convert a timestamp or date into another value I recommend looking into the date and times functions offered in QlikView
Plees ekskuse my Swenglish and or Norweglish spelling misstakes