Get Date from Array String

Help Studio
1

Hi,

I have a problem. I have to create a date from a array. So as an example i have the array:
“M_Any_Wo3_Sa”. I divide these into “M” “Any” “Wo3” and “Sa”.
M = monthly
Any = placeholder for additional information
Wo3 = For the third day of the month
Sat = Saturday

From this information I should determine which date is the third day of collecting in each month.
For example:
16.05.2020
20.06.2020
18.07.2020
etc.

I have other examples as an array:
“M_Any_Wo4_Mi”
“M_Any_Wo1_Fr”

best regards
Jan

2

@JanLuetje What about the Year Information? Also Provide an example String that needs to be the Input

1 Like
3

Hi @supermanPunch

an exampleinput: “ABC_INT_OS_Windows_Full_PG3_M_Any_Wo1_Fr_2000-2400_A”. I split that Arry by “_”. It is always this year in this example.

best regardes
Jan

4

@JanLuetje What is the decoded Date from this String :sweat_smile:

5

@supermanPunch This is the problem :smiley:.

I don’t have a date variable, just this string that needs to be converted to a date variable. So you have to calculate out which is the third Saturday in every month.

6

@JanLuetje No I mean, Do you know the Decoded date for that String :sweat_smile: just by looking into it, or do you have already a Mapping that Points out Which is the Month from the String?

7

I think for the provided string, the expected dates should be the first Friday of each month.

Wo1 = first day of the month
Fr = Friday