Extracting data for a specific time range from Datatime

Data8
Data8 Registered Posts: 4 ✭✭✭

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.

Tagged:

Best Answer

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,162 Neuron
    edited October 11 Answer ✓

    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")
    

Answers

Setup Info
    Tags
      Help me…