Date () function

Hello all!

Could anybody help me with Date() function?

The example of a task is

dateStr – string measure at store level

datetest – date measure at store level

In dateStr we have the strings which conform to the format %Y%m%d, i.e.

……..

“20130304”

“20130305”

…….

I am using the following rule datetest = date(dateStr, "%Y%m%d") and getting the error mesasage:

DateTimeFormat – Parameter () does not conform the specified format ("%Y%m%d") because it does not contain enough characters.

While if I do like this datetest = date(“20130304”, "%Y%m%d"), it works. But it means I only can populate datetest with the same value along the whole hierarchy, It’s not what I need.