Date Fields Help (1 Viewer)

E

Erika

New member

Local time

Today, 17:04

Joined

Nov 1, 2017

Messages

3

• Apr 17, 2018

• #1

Hi,
I currently have a query which shows me a reference, request type, date received, closed date and allocated date. I already have it set to only show open records but I need it to show me if the allocated date has been blank for more than a set number of days from the date received. Is this something which is possible. I am quite new to access so any help would be very much appreciated.

 

P

plog

Banishment Pending

Local time

Today, 11:04

Joined

May 11, 2011

Messages

11,646

• Apr 17, 2018

• #2

You would use the DateDiff function:

https://www.techonthenet.com/access/functions/date/datediff.php

 

E

Erika

New member

Local time

Today, 17:04

Joined

Nov 1, 2017

Messages

3

• Apr 17, 2018

• #3

I would have tried that but one of the date fields will be empty and I need a report to show when this has been empty for more than a set number of days. I can get the query to show me all the records where this date field is empty but apparently we need to know how long it has been empty for.

 

P

plog

Banishment Pending

Local time

Today, 11:04

Joined

May 11, 2011

Messages

11,646

• Apr 17, 2018

• #4

Most likely you want to use the Date() function in your DateDiff.

Date() returns todays date. So, if DateReceived is April 13, 2018 and you use it and Date() in your DateDiff it will return 4 days.

DaysReceived: DateDiff("d", [AllocatedDate], Date())