parsing a date array

Hi Pauls0003,
The following code should serve your purpose.

convert your array using touniformString() function and then this code will work for your case.

load(
local!dates: {
"24/04/2018 12:00 BST",
"29/05/2018 12:00 BST",
"26/06/2018 12:00 BST",
"24/07/2018 12:00 BST",
"21/08/2018 12:00 BST",
"10/09/2018 12:00 BST",
"16/10/2018 12:00 BST",
"13/11/2018 12:00 GMT",
"11/12/2018 12:00 GMT",
"29/01/2019 12:00 GMT",
"26/02/2019 12:00 GMT",
"26/03/2019 12:00 GMT"
},
local!findValue: 10,
index(
local!dates,
index(
where(
a!forEach(
local!dates,
toboolean(
find(
local!findValue,
fv!item,
2
)
)
)
),
1,
- 1
) + 1,
null
)
)


Please let me know if this helps.

Hi,

Its not working for me,

lets suppose if you take the local!findvalue as 12 then its taking the first index and giving me the date "29/05/2018 12:00 BST"

Hi,

Its not working for me,

lets suppose if you take the local!findvalue as 12 then its taking the first index and giving me the date "29/05/2018 12:00 BST"

Try this

load(
local!findMonth: 3,
local!dates: {
"24/04/2018 12:00 BST",
"29/05/2018 12:00 BST",
"26/06/2018 12:00 BST",
"24/07/2018 12:00 BST",
"21/08/2018 12:00 BST",
"18/09/2018 12:00 BST",
"16/10/2018 12:00 BST",
"13/11/2018 12:00 GMT",
"11/12/2018 12:00 GMT",
"29/01/2019 12:00 GMT",
"26/02/2019 12:00 GMT",
"26/03/2019 12:00 GMT",

},
local!dateIndex: where(
a!forEach(
items: local!dates,
expression: mid(
fv!item,
4,
2
) = text(
local!findMonth,
"00"
)
)
) + 1,

index(
local!dates,
if(local!index = 13, 1, local!index)
)
)