How to find if a date column is sunday or not?

[former_member588223]

Use LOAD_D(date column) if this is a Sunday; Otherwise, convert to Sunday’s date; Please note that the most likely day, other than Sunday, is Saturday, in which case simply add 1 to the date.

Experts-How to implement this in bods?

[former_member187605 · Accepted solution]

dateColumn - day_in_week(dateColumn) + 7 always returns (next) Sunday's date

[former_member588223 · Accepted solution]

Hi Dirk,

Any specific logic just to find if a date is sunday or not?

[former_member588223 · Accepted solution]

As per the logic you have provided it is always returning next sunday's date.

What logic we have to apply if we have to get previous sunday's date?

[former_member187605 · Accepted solution]

dateColumn - day_in_week(dateColumn)

[former_member588223 · Accepted solution]

Hi Dirk,

We are joining 6 tables using inner join and we're getting around 30 million records in output.

Can you suggest some valuable performance optimization techniques?

[former_member588223]

Hi Dirk,

USE LOAD_D if this is a Sunday; Otherwise, convert to Sunday’s date. For Monday to Wednesday, use the previous Sunday; For Thursday to Saturday, use the following Sunday.

How to implement this in BODS?

[former_member187605]

isweekend(dateColumn) = 1 and isweekend(dateColumn + 1) =0