measures become #unavailable in SAP Webi

[abhimanyu_sharma]

Hi experts,

When I am trying to format one of my date column from

MM/dd/yyyy to yymmdd, all the data in my measures becomes #unavailable.

Please suggest what could be the issue?

[saurabh_sonawane · Accepted solution]

Hi abhimanyu sharma,

step 1:go to the date column and press right click

step 2: then select format number

step 3: click on date and  select one of the date format,

and click on custom button  it is present in bottom left.

step 4:  write this as syntax in date/time yyMMdd.

Note if u want in format of yy/mm/dd.

then syntax is yy'/'MM'/'dd.

and plz check the below image also.