2 Replies Latest reply on Oct 16, 2018 12:44 PM by sraposo

    Compare date in Table Lookup with current time

    simonsmith0912

      Hi everyone,

       

      I have a simple problem that is just due to my lack of experience (with SQL I think).

       

      I want to reference a table for the value of an attribute, where the value it selects is based on a value in a 'start date' column that is the next one in the future.

       

      See screenshots for explanation:

       

      What do I need to type to compare my date with the time now? I just get 'No data'