Parse Date from String "MM.YYYY" in expression

Questions
#1

I am trying to create an expression ot parse a date formated MM.YYYY, but can’t figure it out.

I am doing it by the luxon documentation.

If I try this is working:
{{DateTime.fromFormat(“12.2022”, “MM.yyyy”)}}

but when I replace the string with output from another module it says not found.

{{DateTime.fromFormat($node[“Monthly Var Setup”].json[“CheckMonth”], “MM.yyyy”)}}

Any ideea what I am doing wrong?

Thanks in advance!
Tiberiu

#2

Hi @Tbiyss, I just ran the below example workflow using your expression and it parses the date as expected for me:

Result:

image
image1347×538 28.2 KB

Is there a chance some of your items don’t have a CheckMonth field? If not, could you perhaps share a workflow using which your problem can be reproduced?