Please help convert equation in Excel to SQL
=IF(DATE(YEAR(TODAY());MONTH(B2);DAY(B2))>TODAY(); DATE(YEAR(TODAY())-1;MONTH(B2);DAY(B2));DATE(YEAR(TODAY());MONTH(B2); DAY(B2)))
=ROUNDDOWN((((1+B4)^YEARFRAC(B2;B3))-1)*B1;2) aa11.zip
Please help convert equation in Excel to SQL
=IF(DATE(YEAR(TODAY());MONTH(B2);DAY(B2))>TODAY(); DATE(YEAR(TODAY())-1;MONTH(B2);DAY(B2));DATE(YEAR(TODAY());MONTH(B2); DAY(B2)))
=ROUNDDOWN((((1+B4)^YEARFRAC(B2;B3))-1)*B1;2) aa11.zip
Learn date functions https://support.office.com/en-us/art...2-658CE330ED83
Use DateSerial()
Instead of cell references, I presume you have fields.
There is no intrinsic RoundDown function. You will have to build your own. http://www.allenbrowne.com/round.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.