calculate Variable using Let

[poluvidyasagar]

Hi,

I am trying to calculate a specific date field which consists of weeknumber, yearnumber, daynumber.

I am able to do this using a text box. However, i would like to calculate during the load and assign it to a variable. 

Expression I want to calculate using load is:

=Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())))

I am using LET to calculate the value. How do i assign to a variable.

I have attached the qvw file.

Thanks,

Vidya

[Janneke]

Hi Vidya,

Instead of :

Let vDate= Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())));

Try:

SET vDate="=Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())))";

Works for me in your example for a text object with expression =vDate

Greetings, Janneke.

[Anil_Babu_Samineni]

This works

Let vDate= '=Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())))';

[poluvidyasagar]

Thanks Janneke.

I am using this variable as a condition on one of my table. But it gives error. 

Here is the code:

set vDate= Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())));

Data:
LOAD [Part Number],
[Final UP],
CNFROM,
CNTO
FROM
Data.xlsx
(ooxml, embedded labels, table is Sheet1)
Where not match(CNFROM,'#N/A','0') and CNFROM < $(vDate);

 I have attached the file. Can you please let me know what is wrong here?

Thanks,
Vidya

[sunny_talwar]

May be you are looking for this

LET vDate = Right(Year(Today()),2) & Week(Today())+4 & Num(WeekDay(Today()))

[sunny_talwar · Accepted solution]

Try this

LET vDate = Right(Year(Today()),2) & Week(Today())+4 & Num(WeekDay(Today()));

Data:
LOAD [Part Number], 
     [Final UP], 
     CNFROM, 
     CNTO
FROM [Data (3).xlsx]
(ooxml, embedded labels, table is Sheet1)
Where not match(CNFROM,'#N/A','0') and CNFROM < $(vDate);

[poluvidyasagar]

I keep getting the error during load.

Can you please check and let me know where is the mistake.

Thanks,
Vidya

[poluvidyasagar]

I think i got it. Concat function is LET is causing the issue.

Thanks Everyone