Design Canvas Artiste

Integer to Date in Nintex Forms

Jump to solution

Hi guys,

I have an issue converting an integer to date in nintex forms.


I have a main list and a task list. Task Items are connected to the main item using Lookup Fields.

Using this formula I am able to get the latest DueDate of the task list for a specific main item:


This however converts the Date field to the integer representation of this field (e.g. "1624485600000").

I found the "convertToDate" and "formatDate" functions but unfortunately they tell me my value is not a number:



Normally you could convert this back to a Date for example using Javascript

var x = new Date(1624485600000)
x.toDateString() //expected: "Thu Jun 24 2021"

 But using this, the form tells me this:



Last part translated: "The object does not support this action". This only occurs when I add the "new Date()" part to a calculated value in the form.

Is there any other way to convert this value back to a date?


I am using Forms for SharePoint 2013


0 Kudos
1 Reply
Design Canvas Artiste

Re: Integer to Date in Nintex Forms

Jump to solution

So after some thought I figured it out:

The integer 0 correlates to 01.01.1970. Given that the integer basically just means "miliseconds elapsed since 01.01.1970", we can calculate the date back using a formula such as

formatDate(dateAddMinutes(convertToDate("01.01.1970"),maxActionDate / 60000),"dd.MM.yyyy")

Using convertToDate we get the "base" date.
As Nintex´ lowest dateAdd* function is dateAddMinutes, we calculate miliseconds to minutes (divided by 60000) and add the result as minutes.
Afterwards we can convert it as it is now a date. 

Somehow using this my date is not perfectly accurate as it shows a day off but I can just add the extra day later using dateAddDays.

View solution in original post

0 Kudos