Duration type and logical comparison to a fixed value.

Assuming your [duration colum] has a duration data type, you need to use this syntax to hard code a duration value

 

if [duration column] > #duration(0,5,0,0) then "yes" else "no"

 

Pat

Hi Anonymous ,

 

I think you can take a look at bleow links which about duration.

 

Reference:

Function	Description
Duration.Days	Returns the day component of a Duration value.
Duration.From	Returns a duration value from a value.
Duration.FromText	Returns a Duration value from a text value.
Duration.Hours	Returns an hour component of a Duration value.
Duration.Minutes	Returns a minute component of a Duration value.
Duration.Seconds	Returns a second component of a Duration value.
Duration.ToRecord	Returns a record with parts of a Duration value.
Duration.TotalDays	Returns the total magnitude of days from a Duration value.
Duration.TotalHours	Returns the total magnitude of hours from a Duration value.
Duration.TotalMinutes	Returns the total magnitude of minutes from a Duration value.
Duration.TotalSeconds	Returns the total magnitude of seconds from a duration value.

 

For instance:

Duration.Second([Datetime Column]) //get the second value(0~59) of datetime

Duration.TotalSeconds([Datetime Column]) //convert datetime value to second

 

Sample: get the diff of date range and convert them to second.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.