Hello, is it possible to do a date range lookup in...
# suitescriptp
Phillip
04/21/2021, 5:18 PMHello, is it possible to do a date range lookup in a script that does a record lookup based upon a search? For example the date is 1/15/2021 and I would like to get the custom record that has a start date and end date within that range
b
battk
04/21/2021, 5:41 PMnot enough information given, 1/15/2021 is not a range
battk
04/21/2021, 5:41 PMmake the search in the ui first, then convert it into a script
p
Phillip
04/21/2021, 5:41 PMI mean plug 1/15/2021 into the range
Phillip
04/21/2021, 5:41 PMhow can I do that?
b
battk
04/21/2021, 5:42 PMphrasing it in a different way will help
battk
04/21/2021, 5:43 PMis 1/15/2021 less than the end date and greater than the start date
p
Phillip
04/21/2021, 5:44 PMthats exactly what I would like to do with the search. like if the start date is 1/1/2021 and the end date is 03/31/2021 and the date being given is in between those two dates
b
battk
04/21/2021, 5:44 PMstart with a filter that compares your end date to 1/15/2021
battk
04/21/2021, 5:45 PMadd another filter that compare your start date to 1/15/2021
👍 1
5 Views