Calculate an Amount at the end of month

Question

Hallo dear collegues,

 

I need help for a query.

I've already searched a little bit about the topic but nothing special the concerns what I'm really looking for. 

 

I have this query: 

 

SELECT loanNR, restcapital, eomonth(dateadd(mm,-1,getdate())) AS 'Restkapital in Vormonat'
FROM [dbo].[Loanplan]

 

This query delivers 3 columns, but i need only two columns.

I need the amount "restcapital" which is estimated at the end of the last month (eomonth).

 

Any suggestions?

Thanks in advance for the answer

 

Best regards

Johannes