I am having a hard time one last portion of a report I am writing, I haven't run into this scenario and would like to hear some input on this one. Also my first question on EE as I normally just read what others have been through.
So here's the situation, I have a field called {Arp} data within is like CM-2017 or M1-2017 etc. I have another field call {ARC} it has data that is the first two digits. CM or M1 and I tried to use a parameter that has -2017 and combine that with the {ARC} to select records from {Arp}
I don't even know if this is possible, I'm just not seeing a way to make this work.
Any help greatly appreciated.
YOu need to convert the year to a string of 4 digits with no decimal palces and no thousand separator
{Command.ARP} = {Command.ARC} & CSTr({?year}, 0,'')
mlmcc