Functions

Owned by Rashmi Likhite
Last updated: Dec 19, 2016
1 min read

A few predefined functions are also available. The purpose of these will be obvious as stated below:


Variable
Usage
Description
formatDate${formatDate(entity.start)}Prints a project date as per the format specified in the viewer's preferences.
Date.format${Date.format(entity.startCalendar, "MM-MMMM")}Prints the Month of project's start date. 11-November
formatDateTime${formatDateTime(entity.start)}Prints project date and time as per viewer's preferences.
formatCurrency${formatCurrency(entity.budget)}Prints a currency field prefixed with the currency symbol as specified in the company profile.
formatNumber${formatNumber(entity.bcws)}Prints a number as per the viewer's locale. Especially useful when printing floating pointing number.
hoursToHHMM${hoursToHHMM(entity.estimatedHours)}Prints hours in the form HH:MM. For example, ${hoursToHHMM(3.5)} will print 3:30
ceil${ceil(5.3)}Returns the nearest integer larger than the input. For example ${ceil(5.3)} will return 6
floor${floor(4.8)}Returns the nearest integer smaller than the input. For example ${floor(4.8)} will return 4
abs${abs(-3.2)}Returns the absolute value of a number. For example ${abs(-3.2)} will return 3.2
round${round(3.6)}Returns the rounded value of input. For example ${round(3.6)} will return 4
Date.now()${Date.now()}Prints today's date.
entity.created${entity.created}Prints the created date of the entity. For e.g, the date when a project was created.
Date.addDays(Date, days) ${Date.addDays(entity.Create_Invoice_Date, 30)}Prints the date after adding the entered days. For example, Create_Invoice_Date is a custom field having a date 13-Oct-2015. So adding 30 days will result in 13-Nov-2015.
.before
.after
.equal 		${entity.New_DueDate).after(entity.completed) : 'OnTime' ? 'Delayed'}Prints On Time or Delayed after comparing first date with second.
Date.isoToDate('date') Date.isoToDate('2016-12-01') Displays date as per your Display date format.