E_DPSG
Board Regular
- Joined
- Jul 17, 2008
- Messages
- 82
Hi all -
I have a query that I am trying to return the closest matching date (but in the past) where I do not get a hit between the joins.
Something like this:
iif(A.DateVal is null, (Select Max(B.DateVal) From B Where (B.DateVal<=A.DateVal)),A.DateVal)
This returns a -1
What am I missing?
I have a query that I am trying to return the closest matching date (but in the past) where I do not get a hit between the joins.
Something like this:
iif(A.DateVal is null, (Select Max(B.DateVal) From B Where (B.DateVal<=A.DateVal)),A.DateVal)
This returns a -1
What am I missing?