Script error with latest extract date

[ashmitp869]

Hi there ,

I am getting an error in qlikview script like below image -

My qlikview script :

SQL
SELECT
CAST(max([StartDateTime]) AS DATE) AS LATEST_EXTRACT
FROM "TEST".dbo.[view_test]
where [Id] in ('aaa','vv','cc');

LET vExtractDate = Num(Peek('LATEST_EXTRACT', 0, 'EXTRACT_DATE'));

SQL SELECT *
FROM "TEST".dbo.[view_test]
where [Id] in ('aaa','vv','cc')
and DATEFROMPARTS(YEAR([StartDateTime]), MONTH([StartDateTime]),DAY([StartDateTime]))>=DATE($(vExtractDate) - 366)

the requiement is to load the data greater than the LATEST_EXTRACT date.

Regards

[MayilVahanan · Accepted solution]

Hi @ashmitp869 

In SQL, there is no built function like "Date". You need to use DateAdd() function, like below

DATEFROMPARTS(YEAR([StartDateTime]), MONTH([StartDateTime]),DAY([StartDateTime]))>=

Cast(DATEAdd(Day, -366,$(vExtractDate)) as Date);