Skip to Content
avatar image
Former Member

Formula in Webi From Date

Hi,

Need help to solve the . i need all in date format

1) Last date of the year from any given date

2) Add 11 month from any given date

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 01, 2017 at 04:36 PM

    Last date of the year=RelativeDate(ToDate("31/12/"+FormatDate(([Your date object]);"yyyy");"dd/MM/yyyy");-1;YearPeriod)

    Add 11 month from any given date=RelativeDate([Your date object];11;MonthPeriod)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2017 at 05:04 PM

    Hi Both,

    Thanks much working fine.

    I have another issue


    I have 2 data providers Q1 contain Material and Q2 contains ISBN. I am merging both at report level.

    (Material and ISBN is list of numbers and both are string)

    eg

    Material ISBN Formula

    111 111 A

    121 122 B

    123 124 C

    Now I want to write a formula based on that saying that

    if (Material =ISBN Then “A” (Eg:111)) ElseIf (if the number only in Material then “B”(eg. 121,123) Else (IF the number only in ISBN then “C”(eg.122,124 )))

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2017 at 04:41 PM

    Hi Sudarshan,

    Please try below formulas:

    1) =RelativeDate(RelativeDate(CurrentDate();1;YearPeriod);-DayNumberOfYear(RelativeDate(CurrentDate();1;YearPeriod)))

    2) =RelativeDate(CurrentDate()); 11; MonthPeriod)

    Regards,

    Anish

    Add comment
    10|10000 characters needed characters exceeded