BusinessObjects Board

Variable with Wildcard in Date

I am trying to create a variable that utilizes the Match function to specify the month the action took place. My field is formatted “03/30/2015 08:23 Yes- New Info; 01/10/2016 07:23 Yes - New Info; 02/15/2017 09:34 Yes - New Info;” I want to populate another field with the month. For example If CCMH contains 02/%%/17 then CC = February so no matter what day in February 2017 it will show February.

I have tried Wildcards %, *, _ , ? and none have worked.

=If(Match([CCMH];“01//2017");“January”;
If(Match([CCMH];"02/
/2017”);“February”;
If(Match([CCMH];“03/**/2017”);“March”;“Reveiw”)))

I’m using 4.1 How can I accomplish this


cwubz (BOB member since 2017-03-03)

Welcome to B:bob:B!

Try these wildcards instead:

=If(Match([CCMH];"*01/??/2017*");"January"; 
If(Match([CCMH];"*02/??/2017*");"February"; 
If(Match([CCMH];"*03/??/2017*");"March";"Reveiw"))) 

Marek Chladny :slovakia: (BOB member since 2003-11-27)

Thank you that worked perfect!! :smiley:


cwubz (BOB member since 2017-03-03)