Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
breno_morais
Partner - Contributor III
Partner - Contributor III

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
neelamsaroha157
Specialist II
Specialist II

try this -

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

View solution in original post

3 Replies
vamsee
Specialist
Specialist

May be try

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

--------

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

neelamsaroha157
Specialist II
Specialist II

try this -

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

breno_morais
Partner - Contributor III
Partner - Contributor III
Author

Exactly what I need. thank you