Siebel Business Process & Functionality (MOSC)

MOSC Banner

how to calculate the day of the month with JulianDay() function

edited May 20, 2015 9:58AM in Siebel Business Process & Functionality (MOSC) 17 commentsAnswered ✓

Hi,

for a given date (provided as an input to the formula) I need to extract the day of the month, the month of the year and the year.

Example:

My input is: 28/01/2014

formula 1 gives me the Day: 28

formula 2 gives me the Month: 01

formula 3 gives me the Year: 2014

formula 2 is: JulianMonth(Today()) - (JulianYear(Today()) * 12)

formula 3 is: JulianYear(Today()) - 4713


But I can't find formula 1

Is there a charitable person here to give me the expression

thanks.

Matthieu

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center