Adding a Flag to Holidays

[villegasi03]

QV Community,

I have a list of company holidays that I would like to join to a table containing daily sales statistics. I am planning to perform an analysis on our sales performance on days that fall on those holidays, the day before the holiday and the day after a holiday. I am familiar with the firstworkday and lastworkday functions so I am able to calculate those dates. What would be the best way to flag these dates?

I was hoping that someone could provide some advice on how to do this.

Thank you

[#2 · Accepted solution]

Hi,

I did that once using the function networkdays:

Load

A,

B,

Date,

if(networkdays(Date,Date,[list of holydays])=1,'Working day', 'Holyday') as HolydayFlag

from ...

Hope this helps

Regards!

[villegasi03]

Worked like a charm! Thank you.