topic Re: Date in QlikView

Date

Anonymous — Mon, 21 May 2018 22:02:04 GMT

Why this expression does not return a value in a text object?

date(Date#('01' & '/' & Month(ReloadTime()) & '/' & Year(ReloadTime()),'DD/MM/YYYY'))

pedrolau — Mon, 21 May 2018 22:34:26 GMT

Hi Pedro, try this: date(monthstart(ReloadTime()),'DD/MM/YYYY')

pedrolau — Mon, 21 May 2018 22:37:01 GMT

If you still want to use your code, you need to use a NUM for the month since this is a dual value, like this:

date(Date#('01' & '/' & NUM(Month(ReloadTime())) & '/' & Year(ReloadTime()),'DD/MM/YYYY'))

mokitsu61 — Mon, 21 May 2018 23:47:34 GMT

How about using Text().

Reference says Date() returns Date object.

Text(Date#('01' & '/' & Month(ReloadTime()) & '/' & Year(ReloadTime()),'DD/MM/YYYY'))