Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

How can I separate a Year/Month field into two fields in script

I have a field named [Year/month] and the values look like this: 2018/01  I need to pull out the Year value and the Month value as a name.  I want to do this in the script.  How can I do this?

10 Replies
sasiparupudi1
Master III
Master III

Long Month

Date(Date#(SubField('2017/12','/',2),'MM'),'MMMM')

Year

SubField('2017/12','/',1)