Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Convert text to Date

Dear all,

I have the field MONTH_REF with value "01 - Januery", how i can convert this for month?

All help will be appreciated

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

try this -

Date(Date#(Left(MONTH_REF,2), 'MM'), 'MMM')

View solution in original post

3 Replies
Highlighted
Specialist
Specialist

May be try

Month(Date#(Trim(Subfield('01 - January', '-', 1)) ,'M') )

--------

Month(Date#(Trim(Subfield(MONTH_REF , '-', 1)) ,'M') )

Highlighted
Specialist II
Specialist II

try this -

Date(Date#(Left(MONTH_REF,2), 'MM'), 'MMM')

View solution in original post

Highlighted
Partner
Partner

Exactly what I need. thank you