Calculate days between dates

just to get the ball rolling... how would I validate the time difference?

if(dateDiffHours(date1, date2)<1)

as per the process: is this an efficient process what I have done so far?
or would you advise something else instead?

simply

dateDiffHours(date1, date2)<1‍

or better (since dateDiff* functions always return absolute value)

dateDiffHours(date1, date2)<1 && (date2 > date1)‍

reg. whether it's not efficient or, I do not know all your requirements.

but very probably I would let users book absence directly to the calendar. they would there decide on their own whether they book just few hours off or all day absence or even repeated absence.

Hey Krishna,

Thanks for the feedback.

The requirements I had was to make a form where users can request, holidays, time off, training, offsite, holiday AM/PM and so forth and so on. At that time, there was no requirement to view the requests in a calendar view

Now since the form is up and running, it has been put forward that it may be good to have a calendar view as well.

With that in mind, my initial form did not ask the users to define the hours, although the date & time were present but nobody bothered to select the times.

When creating the calendar view, as you can imagine, all the requests with dates like this:

from 28/02/2018 00:00 until 29/02/2018 00:00

means that the calendar sees it only one day, although it means to be 2 days from 28th 12am until 29th 11:59pm

So, how to rectify this??

Only thing I can think of is to manually update each request :/

In mean time, I am implementing that BOTH dates (FromDate and UntilDate) are mandatory as well as to validate the UntilDate when it is less than 30minutes between prompt user to specify the time as well. see above formula.

In your scenario, you have created the form in a calendar view  
which is much better but this was not a requirement in my case but came later ...

I am validating with real values.

the example above was my silly mistake!

from 28/02/2018 00:00 until 1/03/2018 00:00

but the formula does not validate it unless both dates are same.

The validation should check if the UntilDate > TIME is not less than 15min

I am  also trying something like this but is not working:

dateDiffDays(FromDate,UntilDate) > 0 && dateDiffMinutes(FromDate, UntilDate) < 15

which means if FromDate and UntilDate is more than 1 day in difference AND time is less than 15min THEN display error.

I'm somehow lost within your explanation, and what problem you exactly experience

could you post how does  dateDiffMinutes(FromDate, UntilDate) evaluate for you and what you see as a problem?

for me the calculation seems to work correctly.

eg.

only problem might be in case difference result is zero. in that case nintex evaluates it to empty string instead of zero.

I'm not sure why nintex decided to do so, by definition the function should always return numeric value.

you might try check like

Number(dateDiffMinutes(UntilDate,CurrentDate)‍) > 0‍‍

CurrentDate reference always returns midnight.

note however, it will work with older forms releases but not in recent ones. there is bug with how CurrentDate evaluates in the recent releases.

add a calculated value control on the form and feed it with following formula.

what does it return?

typeof {Common:CurrentDate}‍

BUT there is a catch:

assuming the From date / time is 10:00 until 15:00

with the above formula, it means that the 15:00 will be flagged as red :/

Maybe I need to change "mm" to "HH" instead .

arrghhhh