Date difference in Adonix language

SUGGESTED

Does anyone know the correct syntax for a workflow if I wanted to compare 2 dates and only show those for which the dates differ by greater than 1 day? In SQL, it's a simple DATEDIFF() to find this number, but I don't know how to code this in X3.

ThX!

Parents Reply
  • 0 in reply to Israel Braunfeld
    I thought about that. I realize now thought that the 2 fields are alphanumeric fields (data type A (len=250 characters)) , not date fields. These are the OVAL and NVAL from the AUDITL table in the data dictionary. I tried this:

    gdat$(day([F:AUL]NVAL),month([F:AUL]NVAL),year([F:AUL]NVAL)) - gdat$(day([F:AUL]OVAL),month([F:AUL]OVAL),year([F:AUL]OVAL)) > 1

    But I can't get it to work. What am I doing wrong?
Children