Extracting data for a specific time range from Datatime

Data8

Hi.

I want to extract data from 7 AM to 10 AM, regardless of the date, in Datetime, but I don't know how to do it.

Thank you.

Turribeach

You said 7AM initially not 7:30AM so you have changed your requirements. 😉

You can use datePart() in a formula to extract the hours and minutes, joined together and filter for records in the 730 to 1000 range:

(datePart(Time_parsed, "hours")*100)+datePart(Time_parsed, "minutes")

Turribeach

In a Prepare recipe use the Extract Date Components processor to extract the hour:

https://doc.dataiku.com/dss/latest/preparation/dates.html#extracting-date-components

Data8

https://community.dataiku.com/discussion/comment/44669#Comment_44669

Thank you. I used that method for filtering as well. However, with this method, it's not possible to filter time range like 7:30 AM to 10 AM. So I'm searching for another solution.

Data8

https://community.dataiku.com/discussion/comment/44671#Comment_44671

Thank you. I solved issue.