Dear community,
I have one complex formula as below and would like to ask what this formula plan to do:
Formula One
IIF((REGEX_Match([NUMBER], "(\d{12})")=-1
AND TONUMBER(Substring([NUMBER],2,2))<13
AND TONUMBER(Substring([NUMBER],4,2))<32)=-1,1,0)
Formula Two
IIF((([DATETIME1] > "2021-05-04 23:59:59" AND [DATETIME1] < "2021-10-01 00:00:00"))=-1,1,0)
Could someone explain what is the function of this formula as i plan to edit the formula after understanding it.
Many thanks for the help