How to filter my Start time in yesterday at 7 AM

[Samanehsorournejad]

Hi every Body :),

I wanted to filter my StartTime Field in Yesterday at 7 Am with Set Analysis. I had write this: 

Timestamp(Timestamp(today()-1+(7/24),'MM/DD/YYYY hh:mm:ss'))

but it did not work unfortunately.

any one has Idea why it did not work?

Thanks in Advanced

[rdelagarde · Accepted solution]

Hi,

This works for me:

Date(Today()-1+(7/24),'MM/DD/YYYY hh:mm:ss')

[Samanehsorournejad]

Thanks in Works 🙂