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

Oracle XE SYSTEM account locked: unlock the SYSTEM user

In some scenarios the SYSTEM user becomes locked after lots of trial of username and password. At that time you can do the following to unlock the same Nvaigate to the SQL plus containing folder and run the following in the cmd propmt window opened from that location > SQLPLUS SYS\ORACLE AS SYSDBA Run the following command: > ALTER USER SYSTEM ACCOUNT UNLOCK; OR > ALTER USER SYSTEM IDENTIFIED BY <any password>; Test the connection as follows: > CONNECT HR/HR
Read more