Skip to Content

Webi if statement for dates

Hi

I need a way to show 'Yes' in a new column if the dates in Occ Start or Occ End for each row fall within the range of dates in the columns TC Start or TC End for that row. Sometimes there can be blanks in the TC Start/End columns and if this is the case I also need the result to show 'No' Hope someone can assist :)

Thanks

Will

sap10.png (52.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Hi,

    For TC Start and End date are null then show "NO"

    If(isnull([TC start Date]) and isnull([TC End Date])) then "NO"

    1st analysis, I'm little confused when you said Range (need a way to show 'Yes' in a new column if the dates in Occ Start or Occ End for each row fall within the range of dates in the columns TC Start or TC End for that row)

    Can you provide more details?.

    Thanks,

    Jothi

  • Thanks Jothi

    I mean that if if the Occ Start/End dates are between the TC Start and TC End dates.

    By way of example: In Ref 1 of my example, I would need the solution to show 'Yes' even though there is only an Occ Start date (no Occ end date) and there is only a TC Start date (no TC end date) because in this example the Occ Start date is >= to the TC Start date and there is no TC End date.

    Hope this helps.

    Thanks

    Will

  • I mean that if if the Occ Start/End dates are between the TC Start and TC End dates in each row

  • Get RSS Feed

0 Answers