Compare if Datetime is Before a Time

[Anonymous]

Hello, I am trying to create a new column by comparing if the datetime is before 5pm on the same day. For example:

If [datetime column] is before 5 pm then "Attend Appt" else "Miss Appt".

Is there any function that can help me with this problem?

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Create a column with below code:-

Column = if(HOUR('Table (2)'[Datetime]) < 17,"Attend Appt","Miss Appt")

Thanks,

Samarth

[Anonymous]

Hello,

May I ask what if i want to make it before 5.30pm?