Magento 2 Product URL with Product Collection – How to Retrieve

Inject class \Magento\Framework\Stdlib\DateTime\DateTime $stdlibDateTime
For example your collection have field from_date and to_date

    // init current time now
    $currentTime = $this->stdlibDateTime->date();

    // Filter datetime
    $collections = $this->getResourceCollection()
        ->addFieldToFilter('from_date', ['lteq' => $currentTime])
        ->addFieldToFilter('to_date', ['gteq' => $currentTime])
        ->setOrder('sort_order', 'ASC')
        ->getData();

If it helps anyone, this is the only way I've managed to get all products, including out of stock products, in a loop for updating the stock values.

I needed to use ->getAllIds() to get an array of all of the products IDs, and then load each product individually rather than loop through the whole collection.

$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');
$productCollectionIds = $productCollection->create()->getAllIds();

foreach ($productCollectionIds as $productId) {
    try {
        $product = $objectManager->create('Magento\Catalog\Model\Product')->load($productId);
        // do actions with product
    } catch (Exception $e) {
        $e->getMessage();
    }
}