I have script :
LET today_year = Year(now());
[Transaction]:
Load
[t_otyp] as [ID transakcie],
[t_odoc] as [Number of transaction],
[t_olin] as [Line],
[t_fprd] as [Fiscal month],
[t_fyer] as [Fiscal year],
;
SQL SELECT
*
FROM [dbo].[ttfgld106107]
Where ([t_fyer] = $(today_year))
It works OK.
But also I want to choose fiscal month. But fiscal month I want to choose in object input box properties. I try write it (red colour is what does´nt work😞
LET today_year = Year(now());
LET Start = PurgeChar(Start, ' ');
IF FindOneOf(today_month, ',') then
LET today_month = Num#(Start) + 0;
Transaction]:
Load
[t_otyp] as [ID transakcie],
[t_odoc] as [Number of transaction],
[t_olin] as [Line],
[t_fprd] as [Fiscal month],
[t_fyer] as [Fiscal year],
;
SQL SELECT
*
FROM [dbo].[ttfgld106107]
Where ([t_fyer] = $(today_year)) and ([t_fprd] = $(today_month));
COULD YOU HELP ME, how I can write for example:
8 into object, save and then reload. Realod will be for 8 month. Thank you.