Hello, I have a quick question. Why are my date f...
# suitescriptp
Phillip
04/26/2021, 11:29 PMHello, I have a quick question. Why are my date filters returning a null value? filters[1] = search.createFilter({ name:'custrecord_pi_startdate', operator: search.Operator.ONORAFTER,values: responseDate });
filters[2] = search.createFilter({ name:'custrecord_pi_enddate', operator: search.Operator.ONORBEFORE,values: responseDate });
b
battk
04/26/2021, 11:32 PMwhat is the value of responseDate
p
Phillip
04/26/2021, 11:55 PM4/26/2021
Phillip
04/26/2021, 11:55 PMthe debugger is showing a value
b
battk
04/27/2021, 12:01 AMthat looks like a string
battk
04/27/2021, 12:01 AMis it a string or a date
p
Phillip
04/27/2021, 12:01 AMI format responseDate as a date
b
battk
04/27/2021, 12:02 AMi still dont know what it is
p
Phillip
04/27/2021, 12:02 AMvar responseDate=format.format({valuetrandate,typeformat.Type.DATE});
b
battk
04/27/2021, 12:03 AMand the value of trandate
battk
04/27/2021, 12:03 AMyou can probably guess at this point that variables are useless to me for debugging purposes
p
Phillip
04/27/2021, 12:03 AMmessage has been deleted
Phillip
04/27/2021, 12:04 AMand custrecord_pi_startdate is a date field on the custom record
b
battk
04/27/2021, 12:04 AMthat looks like a string
p
Phillip
04/27/2021, 12:05 AMok. how can I convert it to a proper date?
b
battk
04/27/2021, 12:05 AMa string looks like
var responseDate = "4/26/2021"
battk
04/27/2021, 12:06 AMa date looks like
var responseDate = new Date()
battk
04/27/2021, 12:07 AMif you think you are having problems with filter values, you should start from hardcoded values
battk
04/27/2021, 12:07 AMand then move onto something more useful
p
Phillip
04/27/2021, 12:09 AMwhen I do convert to a date I get Invalid date value Mon Apr 26 2021 000000 GMT-0700 (PDT) (must match M/d/yy)
b
battk
04/27/2021, 12:12 AMthats normal, search filters want strings
p
Phillip
04/27/2021, 12:17 AMis there anything else I can try? I am trying to compare against the start and end date on the custom record
b
battk
04/27/2021, 12:19 AMwhich record is it supposed to find
p
Phillip
04/27/2021, 12:20 AMthe one where the ratio is 1.0, the start date is 4/1/2021 and the end date is 03/31/2022
Phillip
04/27/2021, 12:20 AMI have another record where the ratio is 1.0, start date is 4/1/2020 and the end date is 03/31/2021
b
battk
04/27/2021, 12:21 AMyour first filter is
Copy code
search.createFilter({ name:'custrecord_pi_startdate', operator: search.Operator.ONORAFTER,values: "4/26/2021"});battk
04/27/2021, 12:22 AM4/1/2021 is not on or after 4/26/2021
p
Phillip
04/27/2021, 12:22 AMwhoops
Phillip
04/27/2021, 12:42 AMthanks for your help