Filter on today's date in Sharepoint List doesn't work

Peki72 I just tried creating a new SharePoint list and list view based on [Today] filter on Date and Time column and it is working fine for me.

Here are the list view settings and all data (all items view) and filtered data (Today items view):

All items view: 

Today items view - Settings: 

Today items view - Output: 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

It seems there are some existing BLANK values in the column, if so you can fill the "Blanks" with some default values and then apply the filter.

Using Power Automate:

1. Create a Flow:

   • Open Power Automate and create a new automated flow triggered manually or based on your requirements.

2. Add Actions to the Flow:

   • Use the "Get items" action to retrieve items from the SharePoint list based on a condition. For example, you might retrieve items where the Date/Time column is empty.

3. Apply Defaults to Blank Values:

   • Use the "Apply to each" control to loop through the retrieved items.
   • Inside the loop, use a condition to check if the Date/Time column is empty.
   • For the items where the Date/Time column is empty, use the "Update item" action to set a default date/time value.

4. Set Default Value:

   • In the "Update item" action, specify the default date/time value you want to assign to the Date/Time column for those items.

5. Save and Test:

   • Save the flow and manually trigger it or set it to run automatically based on your workflow requirements.
   • Test the flow to ensure it updates the Date/Time column for items where the value is blank.

PowerShell Scripting (for advanced users):

Alternatively, you can use PowerShell scripting to achieve a similar result by connecting to SharePoint Online using the SharePoint Online Management Shell:

# Connect to SharePoint Online
Connect-SPOService -Url "https://yourtenant.sharepoint.com"

# Get the specific list
$list = Get-SPOList -Identity "YourListName"

# Retrieve items where Date/Time column is blank
$items = $list.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery())
$context.Load($items)
$context.ExecuteQuery()

# Loop through items and update blank values with a default date/time
foreach ($item in $items) {
if (-not $item["YourDateTimeColumn"]) {
$item["YourDateTimeColumn"] = Get-Date "YourDefaultDateTimeValue"
$item.Update()
$context.ExecuteQuery()
}
}

Replace "YourListName", "YourDateTimeColumn", and "YourDefaultDateTimeValue" with your specific list name, column name, and the default date/time value you want to set.

Always test scripts on a non-production environment before applying changes to your live SharePoint environment to avoid unintended consequences.

Hope that helps !

Note: [Today] will be remained as [Today], I don't think the language is bilingual as far as I knew.