Formula to create start time as midnight

[kwirky]

Hi,
I need a formula to create a start time of midnight on the day the report is run. This report will be automatically generated so I want the report to find that date and time (midnight) all by itself.
The reason is I have a field which is currentdatetime and I need to generate all sales from midnight to currentdatetime.

 

[kwirky]

All okay. I have been able to find a solution. For your reference I used:
datetime(currentdate,time(0,0,0))