advanced access training - How to calculate to 2 different dates

Resolved · Low Priority · Version Standard

Wed 20 Jun 2007, 16:33 Delegate Nawaz said...

Nawaz has attended:
Access Intermediate course

How to calculate to 2 different dates

How to calculate 2 differnet dates

Mon 2 Jul 2007, 12:34 Trainer Carlos said...

RE: how to calculate to 2 different dates

Hi Nawaz

I assume you mean how to calculate the difference between two dates. To do this use the following formula:

=DateDiff(<Interval>, [First Date], [Second date])

The interval can be:

"d" for day, "m" for month,"y" for year, etc

Regards

Carlos

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

advanced access training - How to calculate to 2 different dates

How to calculate to 2 different dates

RE: how to calculate to 2 different dates

Access articles

Access tip:

Using the Quick Access Toolbar in Access 2010