How to subtract the given date from the current date in Access (in Sql mode)?

Question

SQL

You need to create a query in Access that would calculate interest according to deposit accounts. For the calculation, it is necessary that the date of opening the account be subtracted from the current date in order to obtain the value of the months and substitute them into the corresponding formulas for calculating interest on deposits for the current date.
For example:
[DepositAccount]![Amount]*(1+[Account Type]![Percentage]*(CurrentDate(month)-[DepositAccount])/(30*100))
How to write this in Sql ? Since the Access expression builder does not count this.

Answer 1

DATEDIFF
select DATEDIFF(MM, '2014-09-28 15:10:46.813', getdate())