Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm posting a new message here because I couldn't find an answer to my problem elsewhere.
In an output of a tMap, I have a list of dates (every working days of the week until 2050).
I need to identify the first x days of each months that are included in the output of my tMap.
Could someone help me on this?
Thanks a lot!
@Olivier CHAVEE , it's better to provide some example data to explain your requirement, what are input data and what are your expected output?
Regards
Shong
Hi Shong,
The input data is a list of working days dates (Capt1) obtained thanks to a transformation in a tMap.
I have to identify if the current date is in 4 first days of each months.
The final goal is to send an e-mail if the current date is in the 4 first days of each months.
I hope to be clearer with these examples.
Thanks a lot,
Oli.V
Hi @Olivier CHAVEE , if your data type is date you can do something like this in the advanced mode of a tFilterRow component :
input_row.yourColumnName.getDay() <= 4
Send me love and Kudos
Hi Oli
there many variants could be working, as an example:
cheers,