0

Compare 2 Date Fields in the Same Table

Todd Morse

February 25, 2018 22:25

None

Follow

How Do I compare 2 date fields in the same table?  ie Sales Shipment Line Compare the Shipment Date To The Posting Date.

• Facebook
• Twitter
• LinkedIn

13 comments

• 0
  
  Harry Lewis February 26, 2018 15:54

  Do you mean something like one of these?

  =NL("Table","Sales Shipment Line",,"Posting Date","=NF(,""Shipment Date"")")

  or

  =NL("Table","Sales Shipment Line",,"Posting Date","=""<>""&NF(,""Shipment Date"")")

• 0
  
  Todd Morse February 26, 2018 16:12

  Yes Simliar to that.  So If I understand correctly the NF Function knows to Shipment Date field from the Sales Shipment Line by leaving the first function argument <blank>.  Correct?

   

  Thanks

• 0
  
  Harry Lewis February 26, 2018 16:14

  Hello Todd -

  When the first parameter of the embedded NF function is left blank, the function will reference that field for the current record being examined by the NL function (in which the NF function is embedded).

• 0
  
  Todd Morse February 26, 2018 16:18

  Great I am also assuming it works with any type of NL Count ie Rows Count etc...

  Thanks

• 0
  
  Todd Morse February 26, 2018 16:20

  I do have another question while you are on a roll if you don't mind.

• 0
  
  Harry Lewis February 26, 2018 16:33

  Hi Todd -

  Yes, that filtering technique works in a wide variety of situations.  Another question?  Go for it!

• 0
  
  Todd Morse February 26, 2018 16:37

  How can access columns from a link filter table in my NL rows.  Similiar to a SQL inner join or left outer join. 

• 0
  
  Harry Lewis February 26, 2018 17:03

  Todd -

  What is it that you are trying to do?

• 0
  
  Todd Morse February 26, 2018 17:16

  In short I would like to Link the sales line with the sales header and access fields from both tables in the same NL rows function.

• 0
  
  Harry Lewis February 26, 2018 17:36

  You can filter an NL function using fields from another table, using either NL(Filter) or LINK=.

  Also, you can combine information from related tables using the Table Builder and NL(Table) function.

   

• 0
  
  Todd Morse February 26, 2018 17:53

  I have used that before.  Does link = expose the fields from the linked table?

• 0
  
  Harry Lewis February 26, 2018 18:40

  LINK= can be used for filtering... but does not bring in the fields (for example, for use with an NF function).

   

• 0
  
  Todd Morse February 26, 2018 18:47

  Ok That answers my question.  Thanks for all your help.