Showing results for 
Search instead for 
Did you mean: 

Lookup Table search entries. Use formula Mode

Deputy Chef I
Deputy Chef I

Hello Automation Pros,

I've created a lookup table with column timestamp (assigning now()).

However I would like to retrieve all entries with a specific date, let's say today(DD-MM/YYYY) and not the entire timestamp.

I've try using lookup("Employee Failed Audit Lookup Table - DEV","Timestamp":)

but I don't seem to know how to truncate timestamp/change format in the column itself.

I don't want to create a separate column just for storing the current date due to the 10 column lookup table restrictions and endup with 2 columns. one for timestamp and another just for date.

If I search directly in the Lookup table just providing the date it works but not when using search entries.

Thanks in advanced


Deputy Chef I
Deputy Chef I

Try using this formula

lookup("Employee Failed Audit Lookup Table - DEV","Timestamp":(datapill.strftime("%m/%d/%Y")))[Column_name]

Syntax:lookup("TABLE_NAME", "REFERENCE_COLUMN": datapill)["LOOKUP_COLUMN"]

Deputy Chef I
Deputy Chef I

thank you all for your responses!! . I actually opened a ticket service with Workato regarding the lookup function. I am passing datapill.strftime("%m/%d/%Y") but it is not filtering the values and instead returning all entries. For now as suggested I am storing the timestamp without timezone and pulling all records and then storing them on a collection and doing SQL.