Hi Guys,
I am trying to create a query that calculates the number of day between 2 dates.
Colum 1: RMANUMBER
Colum 2: ENTERED
Colum 3: PROCDATE
Colum 4: NumberOfDays
Date 1 is "ENTERED" and date 2 is "PROCDATE" and i would like the number of days between to be in "NumberOfDays"
Can anyone help please?
Many thanks.
I am trying to create a query that calculates the number of day between 2 dates.
Colum 1: RMANUMBER
Colum 2: ENTERED
Colum 3: PROCDATE
Colum 4: NumberOfDays
Date 1 is "ENTERED" and date 2 is "PROCDATE" and i would like the number of days between to be in "NumberOfDays"
Can anyone help please?
Many thanks.