MS SQL allows to get current date in query this way: "select getdate()". In 1C query it doesn't work. I need to get current date in DataCompositionScheme query and I don't know how to do it. Function CurrentDate() doesn't work in queries, only in scripts.
I know that in queries I can use parameters, for example:
Query.Text = "select &getdateparameter";
but is it possible to do the same in DataCompositionScheme query? I can't see such a possibility.
Thank you in advance for your help,