How to calculate the delay in clothes, knowing the period of wearing and the date of write-off?

1

1

1programmer2018-05-21 17:41:38

Microsoft Access

1programmer, 2018-05-21 17:41:38

How to calculate the delay in clothes, knowing the period of wearing and the date of write-off?

Hi all. There is a table

It has a column, the date of write-off
How can I calculate how many days are overdue, from today's date?
That is, you need to display how many days are overdue.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

T

TerNik, 2018-05-21
@TerNik

=DATEDIF(F1,TODAY(),"d")
About function

Similar questions

D

drozd1genadiy2016-02-22 02:53:13

Access database, help? 1Reply

A

Anton2018-09-03 20:53:24

How to fill the columns in the form of MS Access with default values, taking them from the table? 1Reply

A

Alexander2014-04-08 14:20:30

How to export table access to mysql? 2Reply

S

Sasha Pleshakov2016-05-29 19:18:53

How to bind datatable to datagrid using {Binding}? 1Reply

S

Satiata2016-05-30 20:57:55

Problem with subordination and forms in Access, how to solve? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question