EOM using text "MONTH YEAR"

Hi All,

I have a text in the format "Month Year" using this text i want to get end of the month .

Example : 

 Input(Text) : January 2019

Output(date) : 1/31/2019

This is what i could achieve so far but not sure how should i get value "2" which is month (February) . Can somebody help me ?

Thanks in Advance 

  Discussion posts and replies are publicly visible

Parents
  • load(
    local!listOfMonths: {
    "January",
    "February",
    "March",
    "April",
    "May",
    "June",
    "July",
    "August",
    "September",
    "October",
    "November",
    "December"
    },
    local!month: cast(
    typeof(
    1
    ),
    wherecontains(
    stripwith(
    stripwith(
    "February 2019",
    right(
    "February 2019",
    4
    )
    ),
    " "
    ),
    local!listOfMonths
    )
    ),
    eomonth(
    date(
    right(
    "February 2019",
    4
    ),
    tointeger(
    local!month
    ),
    1
    ),
    0
    )
    )

    Create a rule with above code with one rule input (text ),where ever i have specified as bold give that rule input. 

Reply
  • load(
    local!listOfMonths: {
    "January",
    "February",
    "March",
    "April",
    "May",
    "June",
    "July",
    "August",
    "September",
    "October",
    "November",
    "December"
    },
    local!month: cast(
    typeof(
    1
    ),
    wherecontains(
    stripwith(
    stripwith(
    "February 2019",
    right(
    "February 2019",
    4
    )
    ),
    " "
    ),
    local!listOfMonths
    )
    ),
    eomonth(
    date(
    right(
    "February 2019",
    4
    ),
    tointeger(
    local!month
    ),
    1
    ),
    0
    )
    )

    Create a rule with above code with one rule input (text ),where ever i have specified as bold give that rule input. 

Children
No Data