Variable Dates

[#1]

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]

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

[tresesco]

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

=Date(Floor($(vEndDate)))

[jagan]

Hi,

Try like this

vEndDate = Date(Floor(EndDateValue))

vStartDate = Date(Floor(StartDateValue))

Regards,

Jagan.

[#5]

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

[jagan]

Hi,

Can you attach sample file?

Regards,

Jagan.

[#7]

open this link i have attached the sample file

http://community.qlik.com/docs/DOC-6652