Value of item into SQL on anather item

[keminc]

Hi everyone!

Please try to solve a problem with me:
I have item with date and i need to use this date in another [Database monitor] item into SQL, i try this construction but it isn’t work:

SELECT {Monitoring:balance.date.last()} as dt from dual;

So, how I can resolve this case and use value of one item into SQL of another?

[PeterZielony]

That's not the correct syntax

https://www.zabbix.com/documentation/current/en/manual/appendix/functions/history#last

last(/host/key,<#num<:time shift>>)

Never done it this way as you describe but if it would work you would have to fix the syntax to find out

[cyber]

You just cant use one items value as other items paramater(s)....