Webi if statement for dates

[former_member277624]

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

[jyothirmayee_s]

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

[former_member277624]

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

[former_member277624]

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