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
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.