Skip to main content
Nintex Community Menu Bar
Question

Compare DateTime fields

  • July 10, 2024
  • 4 replies
  • 21 views

Forum|alt.badge.img+14

I am comparing 2 datetime fields in a UI field and not sure why I am not getting the results expected.

IF( {{UI_Only_Field__r.Delete_Date_Time__c}} > {{Completed_Date_Time__c}} ,“True”,“False”)

These are the results:

This topic has been closed for replies.

4 replies

Forum|alt.badge.img+11

Bill~

I think your syntax is the problem for the UI only formula. Try IF( {{Delete_Date_Time}} > {{Completed_Date_Time}} ,“True”,“False”).

Thanks!
Karen


Forum|alt.badge.img+14
  • Author
  • July 10, 2024

Why would I not need the __c part of the field name?


Forum|alt.badge.img+10

Bill,

You setup the Model UI fields as part of the Skuid page.  They only exist when you view the page.  Since Salesforce doesn’t know they exist, it doesn’t enforce any naming convention.  Whatever you enter in the Field Id is what you need to use when you reference the field in merge syntax.

Thanks,

Bill


Forum|alt.badge.img+11

Bill~
An easy way to ensure that you are using the correct syntax is to use “Insert Field” and then select the field you want inserted in your UI only formula field, as seen below.
5436808f6e73e95437dcc67aef1a306c87a07d3f.png
Thanks!
Karen