How to calculate delay in days in Access

Navigation
0

Today I use the formula =DIAS(HOJE();H2) to calculate the delay time in Excel:

But this source I extract from Access, does anyone know the syntax to mount this formula in Access?

    
asked by anonymous 04.12.2018 / 13:16

1 answer

1

Try to use the now() function, the formula would look like this: 

Tempo_Pendencia: Round(Now() - [Data_inicio_pendencia], 0)

The formula Round() with zero eliminates decimals.

    
06.12.2018 / 18:10
Test an App on Android. React Native "Table" for queries only - Firebase