Example of Calculated Field: Today, TimeStamp and JulianYear

Here is the example of Exposed Calculated fields
Today()
TimeStamp
JulianYear of Today
JulianMonth of Today
Julian Day of Today
Build a date: Calculation: "0"+(JulianMonth([Created])-JulianYear([Created]) * 12)+"/"+"01"+"/"+(JulianYear([Created])-4713)

For Month:
(JulianMonth([Field])-JulianYear([Field]) * 12)

For Year:
(JulianYear([Field])-4713)




Comments

Post a Comment

Popular posts from this blog

1.) Siebel Install IP 15 Client (Tools and Web Client) in Windows Server 2008 OS

Image
Pre requistes: Windows Server 2008 OS installed system IP 15 Client installations setup(Can be downloaded from http://edelivery.oracle.com with a valid account) STEPS: Tools Installation Download the installables in the local environment and navigate to to the location:"D:\Siebel\15.0.0.0\Windows\Client\Siebel_Tools\Disk1\install\setup.bat". We use this batch file as it has certain parameters that are set with the installation, we can see that when we open the setup.bat file in notepad. Navigate to Next As we don't want any emails to obtained from oracle regarding updates and all thus unselect the checkbox and navigate to next page We select the option"New installation" and navigate to next page As I have only one directory in my local thus I install in C drive. Its advised that we install in D drive and any other drive other than main directory (eg: C) as the same can be salvaged during memory crash, less prone to mem...
Read more

About View Popup Applet in the Standard Interactivity Mode Siebel Applications

Image
Notice Please note that the About View popup is used just for testing purposes in the Standard Interactivity Siebel clients. This is intended as help for developers who want to find out the names of views/applets they are working on. Background The About View popup applet provides details of the screen, view, business object, applet, and business components, currently being displayed in the Siebel application window. This technical note describes how to implement this functionality in the Siebel customer facing applications. Implementation The About View dialog box could be invoked through a button in the frame view bar of the Siebel application.  The button will invoke the “AboutView” method (“About View (SWE)” command) that displays the About View dialog box. The following needs to be configured in Siebel Tools: 1. Siebel Customer Facing Application: First the user needs to determine the template used for the frame view bar of the customer facing application...
Read more