empty variables qlik view

[Vern2022]

Why are my variables empty?

[SalesFunnel_DateParams_temp]:

load

date(date#([dateto], 'YYYYMMDD'), 'YYYY-MM-DD')as [datetonew],
date(date#([datefrom], 'YYYYMMDD'), 'YYYY-MM-DD') as [datefromnew];




    SQL SELECT  *
    FROM [BI_DWH_CORE].[Reporting].[v_QV_COM_SalesFunnel_DateParams];
let va = date(date#([dateto],'YYYY-MM-DD'), 'DDMMYYYY');
let vb = date(date#([[datefrom],'YYYY-MM-DD'), 'DDMMYYYY');
let vblog = 'My name is blob!';

letvblob is fine. that was a test. The date variables contain nothing. PS, the fields do return values in qlik view.

Many thanks.

[Somasundaram]

use this

let va =peek('[datetonew]',0,'[SalesFunnel_DateParams_temp]')

let vb =peek('[datefromnew]',0,'[SalesFunnel_DateParams_temp]')

[Kushal_Chawda]

@Vern2022  What you want to store in variable? Variable holds single value , you cannot call any field directly.