Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
wuensche
Contributor II
Contributor II

dynamic actual date and last year

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

 

1 Solution

Accepted Solutions
engishfaque
Specialist III
Specialist III

Do you mean on frontend? if yes then write:

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

View solution in original post

3 Replies
engishfaque
Specialist III
Specialist III

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
Contributor II
Contributor II
Author

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

engishfaque
Specialist III
Specialist III

Do you mean on frontend? if yes then write:

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