Nested Date functions

[#1]

What does the following script will do if the MonthYear values are like '8-2014' , '11-2013' , '2-2015'.

MonthStart(Date(Date(Date#(MonthYear,'MM-YYYY'),'MM-YYYY'),'YYYYMM')) as P

-James

[sunny_talwar]

Not sure if you need all that, this should be fine and give the same result

MonthStart(Date#(MonthYear,'MM-YYYY')) as P

[#3]

what date# does here ? Examples in the help are not clear. Please clarify.

[lakshmikandh]

Date() vs Date#() | Qlik Community

[sunny_talwar]

It is an interpretation function. When QlikView is unable to understand a particular date format, we can use Date#() to help it understand the format the date is in.

Does that make sense?

[sunny_talwar]

I encourage you to read these blogs:

Why don’t my dates work?

Get the Dates Right