Frank Freese
asked on
Calcualte days between date with leap year
Experts,
Here's my need. If I have a loan dated 9/10/2011 with a maturity date in 30 days. Ths would mature on 10/10/2011. If the loan date was 10/15/2011 it would mature on 11/14/2011. How would my query look, to take into account leap years?
Here's my need. If I have a loan dated 9/10/2011 with a maturity date in 30 days. Ths would mature on 10/10/2011. If the loan date was 10/15/2011 it would mature on 11/14/2011. How would my query look, to take into account leap years?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
look good -
ASKER
thank you
maturityDate:dateserial(ye