dynamic actual date and last year

[wuensche]

Hello everybody,

I need one more time your help.

I have question because I don't know if it is possible.

For a report I need two datefields in one row.

It should be like this:

Weekday       date 2019       date 2020

Do       03.01.2019       02.01.2020

Fr         04.01.2019       03.01.2020

the weekday and the date 2020 i have as fields. But how can I calculate the date 2019, based on the weekday or date 2020?

Does anyone have an idea?

kind regards

[engishfaque]

Hi Wuensche,

Here is a script,

Dates:
Load *, Date(Date([date 2020] + 1, 'dd.mm.yyyy')) as [date 2019] Inline [
Weekday, date 2020
Do, 02.01.2020
Fr, 03.01.2020
Sa, 04.01.2020
Th, 31.12.2020
];

Kind regards,

Ishfaque Ahmed

[wuensche]

Thanks for your answer., but it scould not be in the script. does anybody has an idea, how to solve it in report?

[engishfaque · Accepted solution]

Do you mean on frontend? if yes then write:

Date(Date([date 2020] + 1, 'dd.mm.yyyy'))