Date variable in load script

[aviadbein]

Hi all,

I defined a vLastUpdatedDate variable using LET statement in the load script as following:

RecentDate:

Load Date(MAX("Date")) as MaxDate

Resident DB;

Let vLastUpdatedDate= Date(Peek('MaxDate', 0, DB));

drop table RecentDate;

As you can notice the variable is getting the correct value (26/08/2018) in the variables section inside the app:

When I calling the variable in an object it gets the following value:

Why so?

[shraddha_g · Accepted solution]

in KPI Object try to use

=vLastUpdatedDate

[DavidŠtorek]

Hi,

what is your date format setting in main section  (SET DateFormat='DD.MM.YYYY';)? Try to use some agregation function as it is the only value it doesnt matter and KPI will maybe handel it better.

[aviadbein]

Tnx! It works (not only in KPI object...)!