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:
Solved! Go 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.