How to check current date and time with created field in Sharepoint 2019

Question

Hi all,

Need help on the below requirement.

I have Sharepoint List in Sharepoint 2019 with Title column and default columns like created and createdby. I need all the items created after Today at 7.30Am from that list.

Could you please help me with code.

Answer 1

Here're steps:

1.Create a date and time column named "Today", set default value as Today 7:30 Am.

2.Create a calculated column named "Calculated", use this formula: =IF(Created>Today,"Yes","No").

3.Create a new view -> In the Filter section, set calculated as Yes.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.