Forum

Hi everyone, (Esselamunaleykum)

I created a new infobase and added invoce document, report.

I want to filter invoice date on report, but i dont want use chose date parameter.

I added date parameter and this parameters is not showing. I added 'year' (number) parameter and i added general module convert to date.

But i give expression error. How can i fix that error?

Here .dt (infobase file) : https://yadi.sk/d/2utq-7r__k9CFQ

Pictures

https://yadi.sk/i/K9oLNjjafE_aUw

https://yadi.sk/i/po0rLfwSdmj3MQ

https://yadi.sk/i/7Moft0JQtMPQiQ

https://yadi.sk/i/gWQ3Z036bfEk4g

Thanks.

Dear Mr. Bayraktar,

not very clear what you want to do...

Do you have a report and want to display a list of invoices in this report, while invoices should be selected by date?

Why don't you want to use the default "Date" parameter?

Aleksandr

Dear Mr. Aleksandr,

Q: Do you have a report and want to display a list of invoices in this report, while invoices should be selected by date? - YES

My client can not use date format (01.05.2020). They can use year and month selection values. For example:

Year: 2020, Month: May (Choosen value)

I must do change these selected values to date format (01.05.2020).

Dear Mr. Aleksandr,

When answer my question?

Hello Mr. Bayraktar,

you could use the Date() function, which converts the year, month, and so on to a date value. This is how it looks:

fullDate = Date(2021, 2, 1);