How to calculate Access days lag

Asked

Viewed 316 times

0

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

Planilha Atual - excel

But this source I extract from Access, someone knows the syntax to assemble this formula in Access?

excel ms-access

  • I could already get this column ready in Access, it would save me the time and work of having to create a new column in Excell every time q extract. ( I do this daily extraction)

1 answer

1


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

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

the formula Round() with zero eliminates decimai.

Browser other questions tagged excel ms-access

You are not signed in. Login or sign up in order to post.