Skip to Content
avatar image
Former Member

How to get last date of the current month previous year in webi

If curr date is 17/10/2017. i need 31/10/2016

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 19, 2017 at 10:11 AM

    if your bo version is above bi 4.1 sp06 then use below.

    =RelativeDate(LastDayOfMonth([curr date]);-12;MonthPeriod)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you expert.working perfectly

      I have another problem hope you can help me out.

      I have managed to do an Extended Merge dimension works.

      Q1&Q2 (Merged - Result Expected) Q1 Q2

      111 111 111

      122 122 122

      121 121

      232 232

      But I need to write a single statement formula saying

      IF Id both matches in Cust Id and Emp Id then "A" Eg (100,200)

      IF Id Only in Cust Id Then "B" Eg(300 to 600)

      If Id only in Emp Id Then "C" (700-900)

  • avatar image
    Former Member
    Oct 17, 2017 at 05:19 PM

    Hi Sudarsan,

    Please check the below formulas

    year=todate(DayNumberOfMonth(Curr_date)+Month(curr_date)+relativedate(year([curr_date]);-1);dd/MM/yyyy)

    Prev_date= Relativedate([year];-DayNumberOfMonth([year]))

    Let me know if it works or not.

    Regards,

    Anish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sudarsan,

      Please use the below formulas:

      year=todate(DayNumberOfMonth(Curr_date)+Month(curr_date)+Year(relativedate(([curr_date]);-DayNumberOfYear));dd/MM/yyyy)

      Prev_date= Relativedate([year];-DayNumberOfMonth([year]))

      Please let me know if it works or not.

      Thanks,

      Anish

  • Oct 19, 2017 at 09:44 AM

    use this.

    =LastDayOfMonth([curr date])

    Add comment
    10|10000 characters needed characters exceeded