Tag Archives | BendixKiel

Various ways to show a Date field

Find your favorite way to show a Date field by looking at the following image:   In order to achieve this, just copy paste one of the following Javascripts in a Calculation field. 1) moment(@Date).tz(“Europe/Copenhagen”).format(“dddd DD/MM/YYYY, hh:mm A”) 2) moment(@Date).tz(“Europe/Copenhagen“).format(“ddd DD/MM/YYYY, hh:mm A”) 3) moment(@Date).tz(“Europe/Copenhagen“).format(“ddd DD/MM/YYYY, HH:mm”) 4) moment(@Date).tz(“Europe/Copenhagen“).format(“ddd DD/MM/YYYY”) 5) moment(@Date).tz(“Europe/Copenhagen“).format(“DD/MM/YYYY hh:mm A”) 6) moment(@Date).tz(“Europe/Copenhagen“).format(“DD/MM/YYYY”)   Make sure […]

Read full story · Comments { 0 }

Create a Date field from Text fields

Let’s say you have a date separated into three Text fields and you want to merge all of them into one Date field. That is possible, you can create Date fields with your information. Just copy paste the following code to a Calculation field: var d = new Date(); d.setDate(@DD (Text)); d.setMonth(@MM (Text) – 1); d.setFullYear(@YYYY (Text)); d /* ——————————————————————————————————- Created […]

Read full story · Comments { 0 }

Create a Date field by using Number fields

You can create a Date field using three different Number fields, which of course will contain the day of the month, the month, and the year. Just copy-paste the following code to a Calculation field:   new Date(@YYYY, @MM – 1, @DD, 0, 0, 0 )  /* ——————————————————————————————————- Created by BendixKiel ApS – Copenhagen based Podio Preferred Partner -with […]

Read full story · Comments { 0 }