convert month and year pick list into a date for processing

I have an entity in dynamics crm where the month is captured from a pick list and the year is captured in a separate picklist. In Scribe I can see 2 values. Month = 1-12 and year = 2016, 2017, 2018 etc.

 

I need to create a map that finds records where the date in the record is now passed. For example. If I have a record where the month value is "10" and the year value is "2017". Then when this map runs on 1st Nov it should locate this record because we have now gone past October.

 

Thanks

(2) Answers

Login