Incorrect, if they had it in stock or not, they would obviously be able to tell you, even if before the street date.
Yeah but if you ask someone to look it up, as not every store's signage team members do their jobs correctly, they can tell you whether or not they have any in the back, the street date if they have it, and can give information on when they might get the item in. Though it varies from case to case as not all will or even know how to.
As someone who works in the backroom at a Target, I can tell you that given JUST a DPCI# the only thing we can tell you is if it is located on a shelf in the backroom. We won't be able to tell you if it's in the store or not, we won't be able to tell you what date it will be set out, and we definitely won't be able to tell you when we might get an item in.
-DG