Why following query gives "Wrong parameter" error?

SELECT
   DATETIME(YEAR(&Period), MONTH(&Period), 7) AS MyCustomDate
INTO DatesRawData

This construct will not work! The 1C query language is not a full SQL language, and of course it has its limitations… For example, the DATETIME function only works when numeric parameters are passed to it. And although the result of the YEAR function is also of type Number, DATETIME still does not accept it…

In your case, you can do it differently:

SELECT
   DATEADD(BEGINOFPERIOD(&Period, MONTH), DAY, 7) AS FIELD

Attached Files

Download Scr_1.png (6.37 KB)

Well, I wanted to generate all days of a given date, "&Period".

If "&Period" is 2025-12-17 then I must generate

2025-12-1
2025-12-2
2025-12-3
...
2025-12-31

I did following query

[CODE][/CODE]

(I can't continue editing this post of mine. I am frequently getting "Access denied" error)

Hello Bahrom,

could you please clarify: is this for a learning exercise or for a real work project?

The reason I ask is that due to the limitations of the query language in 1C, it's sometimes easier to perform certain operations directly in 1C code rather than within a query.

I'll try to help you either way, but please keep this in mind