Age & Past Due

[Cleis]

Hello group!

I have created a query that allows me to calculate how long it takes for me receive payments from my suppliers (via a crosstab query). Now I want to use the following w/o hardcoding the 7/31/2007. How do I make the year a variable without using the DateSerial() function?

Take a peek at this:

Jul1: IIf(IsNull([Jul]),DateDiff("d",Date(),#7/31/2007# -[AVG Of DaysOutstanding]),[Jul])

Yes this does work but it's

 

[SkipVought]

Hi,

This is not a VBA question.

"Now I want to use the following w/o hardcoding the 7/31/2007"

What does 7/31/2007 represent, on this, the 6[sup]th[/sup] of October?

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[dhookom]

What are you attempting to calculate? What is the SQL view of your crosstab?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Cleis]

Thanks dhookom and skipvought!

I got my answer from RuralGuy although I would up creating a modual.

http://www.tek-tips.com/viewthread.cfm?qid=1414049&page=1