Create a Date field by using Number fields

markdown15.2

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 more than 6 years of experience in helping organizations implement Podio. Please feel free to contact us if you need help evaluate, structure or implement Podio in your organization.

BendixKiel ApS www.bendixkiel.org +45 71 99 05 80 anders@bendixkiel.org

———————————————————————————————————– */

 

Make sure that you replace:

@YYYY : with your app’s year Number field

@MM : with your app’s month Number field

@DD : with your app’s day-of-the-month Number field.

 

Let’s apply these changes in “Modify Template”. (Don’t forget to unclick the time display option of your Calculation field).

markdown15.1

gives us the following result:

markdown15.2

, , ,

No comments yet.

Leave a Reply