If I were to want to return all sales orders that ...
# suitescripts
screnshaw
05/27/2022, 8:17 PMIf I were to want to return all sales orders that were last modified before 5/27/2022 4:17 pm, how would I do that in a saved search?
b
battk
05/27/2022, 8:43 PMhave you tried using the
Date Last Modifieds
screnshaw
05/27/2022, 8:44 PMI did, but it won't remember the time when I enter it in
b
battk
05/27/2022, 8:45 PMwhat does the code look like?
s
screnshaw
05/27/2022, 8:45 PMNo code, it's just a saved search. I removed the code a while back because it wasn't working either
screnshaw
05/27/2022, 8:45 PMIt's like it just truncates the time
b
battk
05/27/2022, 8:47 PMyou wont be able to get down to specific minutes in the ui
s
screnshaw
05/27/2022, 8:52 PMAh. It shows time in the UI so I was hoping it would
b
battk
05/27/2022, 8:53 PMyou can do it from script, but the ui only lets you select hours
s
screnshaw
05/27/2022, 8:53 PMso javascript not not a search formula then?
b
battk
05/27/2022, 8:57 PMa formula should work fine as well
s
screnshaw
05/27/2022, 8:58 PMohhhh. Do you happen to have one that you could easily add in here? If not, I can find one
b
battk
05/27/2022, 8:58 PMit just requires you to know how to parse a string as a timestamp
👍🏼 1