You can try this out
[day-from-dateTime(CreatedAt) = day-from-dateTime('[%CurrentDateTime%]')]
[month-from-dateTime(CreatedAt) = month-from-dateTime('[%CurrentDateTime%]')]
[year-from-dateTime(CreatedAt) = year-from-dateTime('[%CurrentDateTime%]')]
[Status = 'Submitted']
XPath query will fetch the record based on day, month, and year. So, it doesn’t require the range and it will retrieve the current day records.
Please try below one
[day-from-dateTime(CreatedAt) = day-from-dateTime('[%CurrentDateTime%]')][Status = 'Submitted']
You can do something like this:
[CreatedAt >= '[%BeginOfCurrentDay%]'][ CreatedAt <= '[%EndOfCurrentDay%]'][Status = 'Submitted']
This will filter out the records created between the start and end of the current day.
Hope this helps.