topic Re: Variable Dates in QlikView

Variable Dates

Fri, 23 May 2014 10:21:38 GMT

How to change my variable date in date format when i give vStartdate and vEnddate they automatically change my date in points forms.

see the attachement plz.

jagannalla — Fri, 23 May 2014 10:25:30 GMT

Hi,

Date($(vEndDate),'DD/MM/YYYY')

or try to store date format in script level

for eg:

Let VEndDate = Date( YourExpression,'DD/MM/YYYY')

Cheers!!

Jagan

tresB — Fri, 23 May 2014 10:25:36 GMT

If you want to disregard decimal part and get date, then try like:

=Date(Floor($(vEndDate)))

jagan — Fri, 23 May 2014 10:28:26 GMT

Hi,

Try like this

vEndDate = Date(Floor(EndDateValue))

vStartDate = Date(Floor(StartDateValue))

Regards,

Jagan.

Fri, 23 May 2014 10:34:58 GMT

HI it still not work i tried all your three tips as mention in comments.

jagan — Fri, 23 May 2014 10:39:01 GMT

Hi,

Can you attach sample file?

Regards,

Jagan.

Fri, 23 May 2014 10:45:09 GMT

open this link i have attached the sample file