Last working day of the month in LOV

system · December 14, 2006, 11:30am

I have a field for ‘date’.Is there a possibility in BO to display only the last WORKING days of each month when it prompts for date?
THANK YOU.

cris (BOB member since 2006-10-17)

system · December 14, 2006, 3:41pm

You don’t say what database you are using, in Oracle we simply say:-

last_day(tablename.datename)

Mak 1 (BOB member since 2005-01-06)

system · December 14, 2006, 6:31pm

Thank you for the reply.
we r working on Sybase and BO 5.1.8, FC.

cris (BOB member since 2006-10-17)

system · December 14, 2006, 6:58pm

Hi,

Even last_day() won’t give you what you need, as it only returns the last day of the month, which won’t necessarily be a working day.

Most people build a Calendar table for this kind of query. The table would include a flag to indicate whether the day is a working day or not.

Good luck,
Judy

JMulders (BOB member since 2002-06-20)

system · December 15, 2006, 10:39am

Doh! Judy,

Should have read the question better

Judys right, a calendar tables always the right way to go, although I have seen people on this board attempt to do this at report level…

Mak 1 (BOB member since 2005-01-06)

system · December 15, 2006, 2:08pm

Thanks you both for replying.
Can you please let me know in more detail how to do this at the report level :?

cris (BOB member since 2006-10-17)

system · December 15, 2006, 2:21pm

Try this to get you started:-

Mak 1 (BOB member since 2005-01-06)