Load yesterday data

[Anonymous]

Hi guys,

I want to load only yesterday data from SQL.

I create variable

Let vToday = date(Today()-1);

Load date(floor(submitDateTime)) as oDate,*;

FROM.dbo.Data

    WHERE submitDateTime='$(vToday)';

I load exactly time 2013-07-09 00:00:00.

Who can help me round my condition?

I know I can use condition add new variable today and use

WHERE submitDateTime>='$(vToday1) and submitDateTime<='$(vToday)';

Thanks,

[ariel_klien]

Hi

Try

    Let vToday = DATE#(Today()-1);

...

...

...

    WHERE DATE#(submitDateTime)='$(vToday)';

BR

Ariel

[Anonymous]

Hi

Thanks for reply.

It didn't work, because vToday is number format. submitdatetime is 2013-07-09 00:00:00

Thanks,

[ariel_klien]

Try

    Let vToday = DATE#(Today()-1,'YYYY-MM-DD');

...

...

...

WHERE DATE#(submitDateTime,'YYYY-MM-DD')='$(vToday)';

BR

Ariel

[Anonymous]

QV date# is not recognized built-in function name.

[ariel_klien]

OK

Try to Lose the #

use only Date(submitDateTime,'YYYY-MM-DD')

[Anonymous]

the same.

didn't work

[Anonymous · Accepted solution]

Maybe somebody knows better way than that

Let vToday1 = date(Today()-1);

Let vToday = date(Today());

FROM Data

    WHERE submitDateTime>='$(vToday1)' and submitDateTime<'$(vToday)';

Thanks,