Datetimediff issues

Questions and Help
1

Howdy folks!

Trying to get datetimediff to work.
I am trying to compare 'New date' which is inputted in the form with the date 'date changed' which is part of a data blaze spreadsheet. If the date changed is longer than 14 days from new date, I want it to output a text. but output nothing if it is within 14 days. this is what I got so far, and doesnt seem to be doing anything

{if: datetimediff(new date, date changed, "D") <=14}
{else}
-Nursing to do an updated assessment. Nursing aware.
{endif}{endif}

any suggestions?

2

Hi @bkoch

This works for me, please check this example:

New date: {formdate: YYYY-MM-DD; name=new date; default=2025-03-01}
Date changed: {formdate: YYYY-MM-DD; name=date changed; default=2025-03-18}

Days diff: {=datetimediff(`new date`, `date changed`, "D")}

{if: datetimediff(`new date`, `date changed`, "D") <=14}
{else}
-Nursing to do an updated assessment. Nursing aware.
{endif}