FormatDate

returns the local date and/or time formatted as specified syntax formatdate(date, format, timezone) enabled for for a description of the business object categories, see notes on "enabled for" docid\ u26v9fecfs6ilwa0 pvjd business object category yes/no business rules before save rules yes business rules calculation rules (after save, with or without also recalculate on load) yes business rules calculation rules (before save or always, without also recalculate on load) yes business rules calculation rules (before save or always, with recalculate on load) yes business rules editing rules yes1 business rules initialization rules yes business rules read only rules no business rules required rules yes1 business rules validation rules yes1 client expressions no object permissions no services yes ldap yes mobile yes quick actions (except export to microsoft excel quick action and ui quick actions) yes ui quick actions no reports yes search/dashboard without field references yes search/dashboard with field references yes except when this field appears on a form or is triggered by such a field parameters parameter description date the date and/or time to format format the format for the date and/or time see standard date and time format strings https //learn microsoft com/en us/dotnet/standard/base types/standard date and time format strings for information about the accepted formats timezone (optional) the time zone, in iana format return value string representation of date time value example $(formatdate(resolveddatetime, "dd mm yyyy hh\ mm")) if the value of the resolveddatetime field is april 14, 2017 at 1 25pm , the above example returns 14 04 2017 13 25