Help in Filtering DATETIME by by time -hours

Dear All

Would you know if there is a formula/function to filter a DATETIME column on the basis of TIME. In other words I would like to filter occurrences of events, everyday, lets say between 2:00 AM and 5PM in last month. The DATETIME format that I have is YYYY-MM-DD HH:MI:SS.

Thank you in advance

Date Time

Accepted answers

DataNath

Could use the DateTimeHour() function. As you want to check between 2am-5pm then you just need this to be >= 2 and < 17 (assuming 24 hour):

Filter based on hours.yxmd

All comments

IraWatt

Hey @RafalRazny,

This method works:

You just need to separate out the time variable as a time data type and compare that to a string in a time format.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

DanielG

@RafalRazny

Within a filter tool, just put this: DateTimeHour([DTField])>2 and DateTimeHour([DTField])<17

Where DTField is the field you are filtering on.

No need for a separate formula.

Just make sure the DTField is a DateTime datatype, otherwise it will likely return a 0 for the hour.

DataNath

Could use the DateTimeHour() function. As you want to check between 2am-5pm then you just need this to be >= 2 and < 17 (assuming 24 hour):

Filter based on hours.yxmd

DanielG

Obviously if you want to include 2AM and 5PM you'd change it to >= and <= in there. 😀

RafalRazny

Thank you! I have used the DateTimeHour function in Filter tool and it works well!. Great job @DanielG and @DataNath!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703