Skip to Content
0

converting a date

Dec 07, 2016 at 10:48 AM

13

avatar image

Dear NG,

I have trouble converting a date.

There is a given field in WEBI called date_now and I would like to convert this date and write it into a new variable called date_old.

The following canversions should be done:
- reduce the year by oen
- set the day to 01

For example:

date_now = "07.12.2016" ---> date_old = "01.12.2015"
date_now = "23.05.2016" ---> date_old = "01.05.2015"
date_now = "17.03.2014" ---> date_old = "01.03.2013"

It seemed quit easy in the beginning, but now I am struggling ...
Any help is appreciated!

TIA,
Henning

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers