Previous Day of DATE in script

[volcore79]

Hi,

via a load script i get a date field in qlikview. now i need the previous day of this date. how do i get it ?

For example:

LOAD

Date1 as BeginDate,

Date2

as EndDate,

Date1

-1 as DayBeforeBeginDate

FROM

[Test.xlsx]

(

ooxml, no labels, table is Zeitplan);

A,

[Miguel_Angel_Baeyens · Accepted solution]

Hello Volker,

Use the following instead

Date(Date(Date1) - 1) AS DayBeforeBeginDate

Hope that helps

EDIT: Nested Date() so the value is always numeric.

[#3]

Hi,

Try whit this

MakeDate(year(BeginDate),month(BeginDate),day(BeginDate)-1)