Issue with Date Field

[#1]

Hi stalwar1‌ ,sunny‌

Attaching the sample  qvw. Want to change the date in the front end, as a conditional dimension.

Thanks for the help Sunny.

[sunny_talwar]

Conditional dimension or you meant calculated dimension? Try this

=Date(Date#(YR_MTH_KEY, 'YYYYMM'), 'MMM-YY')

[#3]

I tried out your expression in the calculated dimension. This is what I got..:(

[sunny_talwar]

Can you post a screenshot of just YR_MTH_KEY?

[#5]

[sunny_talwar]

I mean it works in the sample you have provided, right? I guess the only other things you can try this

=Date(Date#(Text(YR_MTH_KEY), 'YYYYMM'), 'MMM-YY')

[MarcoWedel · Accepted solution]

it seems you are interpreting the underlying numerical value of an already dual loaded date field with the date#() interpretation function.

Try to just use the formatting Date() function

Date(yourdatefield, 'MMM-YY')

hope this helps

regards

Marco

[#8]

Sunny, It worked with =Date(YR_MTH_KEY,'MMM-YY')

[sunny_talwar]

Hahahaha okay