Skip to Content

Difference between two date fields QUERY manager

I need to see the difference between two date fields for example:

SELECT T0."DocNum", T0."DocDate", T0."DocDueDate"

The difference between: (T0."DocDate " - T0."DocDueDate") = X days

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 26, 2017 at 10:53 PM

    Hi,

    Try this function,

    Datediff(day, T0.docdate, T0.Docduedate) = X days.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 28, 2017 at 10:34 PM

    Run below function to get number of days in query generator

    Datediff(day, T0.docdate, T0.Docduedate)

    Add comment
    10|10000 characters needed characters exceeded