AnsweredAssumed Answered

Compare date in Table Lookup with current time

Question asked by simonsmith0912 on Oct 16, 2018
Latest reply on Oct 16, 2018 by sraposo

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'

Outcomes