Tarf
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.

Scenario:

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:

max(lookup("Tasks","LookupField:ID",{ItemProperty:ID},"DueDate",true))

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:

Tarf_0-1625555286736.png

 

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:

Tarf_1-1625556113090.png

 

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

Thanks!

0 Kudos
Reply
1 Reply
Tarf
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
Reply