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)
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)
This comment has been removed by the author.
ReplyDelete