Skip to main content
faraza4154
December 2, 2022
Question

Compare two dates in appian

  • December 2, 2022
  • 4 replies
  • 0 views

How can we compare now() with the date for example dueDate if its ON TRACK or OVERDUE?

4 replies

stefanhelzle0001
Brainy
December 2, 2022

Did you try to use "=" or "<>"?

faraza4154
December 2, 2022

Yes I have used ">"
like this "12 Nov 2022" > "05 Nov 2022"

mikes0011
Brainy
December 2, 2022

"now()" returns data in the DateTime data type - if you want to compare it against something else, you'll need to compare it against another DateTime value to get any meaningful result.  The values you posted in your comment above won't evaluate to anything meaningful if you're just trying to compare two strings.

The Expression Guru