OK now I am confused.?
I *thought* that you could just use DateSerial(Year(Date()),Month([Transactiondate]),Day([TransactionDate])) to get the current birthday and compare against Date() and Date()+7, but I also get a type mismatch.
MS docs say DateSerial returns a Variant(Date) https://support.microsoft.com/en-gb/...a-93f2b046f503 which I always thought was a date, though I have not used it much myself.
Even tried CDate() on the returned value and still get Type mismatch?
The date functions even work on the result?
Code:
SELECT DateSerial(Year(Date()),Month([Transactiondate]),Day([TransactionDate])) AS NextBD, Day([nextbd]) AS Expr1, Month([nextBD]) AS Expr2, Year([nextBD]) AS Expr3
FROM Transactions;
and even this works?
Code:
SELECT DateSerial(Year(Date()),Month([Transactiondate]),Day([TransactionDate])) AS NextBD, Day([nextbd]) AS Expr1, Month([nextBD]) AS Expr2, Year([nextBD]) AS Expr3, [nextbd]+7 AS Expr4
FROM Transactions;