AnsweredAssumed Answered

Determine date format from output of date picker

Question asked by M S on Apr 22, 2016
Latest reply on Apr 25, 2016 by patrickabel

In Nintex Forms I need to create an equals statement that checks against a hardcoded date. The problem I have is that I cannot determine the correct format for the hardcoded date to result in a "true" outcome.

 

As per the screenshot below, I have a date control called Date1 and a calculated value on the form:

1.PNG

 

I have configured the calculate value like this:

2.PNG

 

equals("27 April 2016 00:00:00", Date1)

 

When I use a calculated value to extract the value of the date picker it returns "27 April 2016 00:00:00" and I've tried pretty much all other variations I can think of e.g.:

  • 27/04/2016
  • 27-04-2016
  • 2016-04-27
  • 1461715200
  • 2016-04-27T00:00:00+00:00
  • Wed, 27 Apr 2016 01:00:00 +01:00

 

Any help would be appreciated

Outcomes