How to determine if a date is a holiday?

[Andrew2009]

I have a date and I want to check if it's a holiday or not. how do I do that please?

Thanks
JDE 9.1

 

[alfredorz]

Hi Andrew,

You can use B1700690 - F0007 Get Day of Week BSFN, you pass the branch plant and date, this bsfn check branch/plant calendar P00071, and return day of the week (for you is not relevant) and type of day. You check if this value of type of day ('W' Work, 'H' Holiday, 'V' Vacation, 'E' Weekend), etc.

I hope it help you.

Regards,
Alfre.

 

[johndanter]

Hi Andrew,

First you need to define holiday
If you mean bank holidays and stuff like that then maybe add them to the workday calendar and check there?

https://docs.oracle.com/cd/E16582_01/doc.91/e15152/set_up_tms.htm#EOATM00065

 

[Lennon2]

I have differents calendar types, is posible the filter ? the BSFN only accept two parameter (branch plant and date)

 

[JohnDanter2]

I have differents calendar types, is posible the filter ? the BSFN only accept two parameter (branch plant and date)

Try N000700 in I mode (I for Inquiry)
Then you can see the difference in WDCT and WDCK between them

But you'll have to split your date apart then check the day against the corresponding TD01 to 31 flags in a big nasty IF

 

[DSauve]

There's always the low-tech way - look out in the parking lot and see if anyone is there! Just kidding - couldn't resist!