Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Policy Automation
Oracle Policy Automation - General Discussion
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 19, 2013 2:58 PM by
Temporal values inside of Excel
Apr 19, 2013 2:26 PM
I have a logic puzzle for today.
Is there a way to put the following into Excel sheets verbatim and then make it temporal with other rules?
2010-01-01 New Year's Day
2010-01-18 Dr. Martin Luther King, Jr. Day
Of course, I know about using "Apply Sheet" so that I can have a worksheet for each year, and I know I could do the following:
TemporalOn(2010-01-01) New Year's Day
TemporalOn(2010-01-18) Dr. Martin Luther King, Jr. Day
But, is there a way to take the original form of "2010-01-01" and "New Year's Day" in Excel rows and then make it temporal? I am looking for a larger pattern via this simple example...
This content has been marked as final.
Show 1 reply
Re: Temporal values inside of Excel
Apr 19, 2013 2:58 PM
in response to
Wait, I found a whacky solution...
the holiday dates = AddDays(2010-01-01, TemporalDaysSince(2010-01-01, 2010-12-31))
then, using "the holiday dates" as a condition and "the holiday name" as a conclusion in Excel...
the holiday dates | the holiday name
2010-01-01 | New Years day
2010-01-18 | Dr. Martin Luther King, Jr. Day
Whacky, but performance aside, it works...