converting a date

[former_member318041]

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

[mhmohammed]

Hi Henning,

Assuming that the data type of date_now is Date, try to use this formula.

Date_Old
=Todate(FormatDate(RelativeDate([date_now];-1;YearPeriod);"MM")+"/01/"+FormatDate(RelativeDate([date_now];-1;YearPeriod);"yyyy");"MM/dd/yyyy")

Try that and let us know.

Thanks,
Mahboob Mohammed