Skip to Content

converting a date

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 11, 2018 at 09:35 PM

    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

    Add comment
    10|10000 characters needed characters exceeded