Return values from yesterday date

[pvl55]

Hi, I want to pull in date parameters (# of days left in QTR, etc.) from a table based on yesterday's date. Is this possible in a simple access query?
Example: Latest invoice date is 8/24. Being its 8/24, query needs to pull days remining in QTR at that time.


I have a full table to show date parameters.
Thanks

[Bob Fitz]

The attached db has some date function which may be of use

[davegri]

Here's a function that will calculate days remaining in quarter from yesterday.

Public Function fcnDaysRemainingInQuarter() As Long
    Dim y As Long, m As Long, d As Long, qEndDate As Date
    y = Year(Date - 1)
    m = 3 * Int((Month(Date - 1) - 1) / 3) + 4
    d = 0
    qEndDate = DateSerial(y, m, d)
    fcnDaysRemainingInQuarter = DateDiff("d", Date - 1, qEndDate)
End Function