?
Solved

Between Date and Year End

Posted on 2014-11-14
5
Medium Priority
?
224 Views
Last Modified: 2014-11-14
Experts,

I need a formula that returns data between the current date and the year end.

I have the following and I need to modify it as so.
Between Date() And Date()+Nz([Enter Number of Days in Future],100000) Or Is Null

thank you
0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 48

Expert Comment

by:Dale Fye
ID: 40442915
I prefer the following syntax:

>= Date() AND < DateSerial(Year(date()) + 1, 1, 1)
0
 
LVL 48

Expert Comment

by:Dale Fye
ID: 40442926
Not knowing whether the field you are trying to filter on contains only date data, if you use the BETWEEN syntax, and use DateSerial(Year(Date()) + 1, 1, 1) then you would also retrieve data for Jan 1, 2015.  By using the < you are certain to get only data pertaining to 2014.
0
 

Author Comment

by:pdvsa
ID: 40443024
Dale, thanks.  I think I need to include days that are 5 days after year end.  I think I would need Between and that DateSerial if I am thinking correctly.  Not sure exactly what I need to change for 5 days after year end.  Could you help me with that?
0
 
LVL 51

Accepted Solution

by:
Gustav Brock earned 2000 total points
ID: 40443197
That would be:

Between Date() And DateSerial(Year(Date()) + 1, 1, 5)

/gustav
0
 

Author Closing Comment

by:pdvsa
ID: 40443596
Perfect.  Thank you
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question