Discussion Board for collaboration related to QlikView App Development.
Dear all,
I have the field MONTH_REF with value "01 - Januery", how i can convert this for month?
All help will be appreciated
May be try
Month(Date#(Trim(Subfield('01 - January', '-', 1)) ,'M') )
--------
Month(Date#(Trim(Subfield(MONTH_REF , '-', 1)) ,'M') )
try this -
Date(Date#(Left(MONTH_REF,2), 'MM'), 'MMM')
Exactly what I need. thank you