Forum Discussion
change duration format to decimal
the problem is for the below condition
DateTime.Date( DateTime.LocalNow() )-[First Seen] <= 30
in the left site of <= we have duration format in the right side we have number, change the number to duration by using #duration(30,0,0,0).
I also recomended to use the below formula for this part in some cases your format might be mismatch.
(Date.From( DateTime.LocalNow() )-Date.From([First Seen])) <= #duration(30,0,0,0)
the problem is for the below condition
DateTime.Date( DateTime.LocalNow() )-[First Seen] <= 30
in the left site of <= we have duration format in the right side we have number, change the number to duration by using #duration(30,0,0,0).
I also recomended to use the below formula for this part in some cases your format might be mismatch.
(Date.From( DateTime.LocalNow() )-Date.From([First Seen])) <= #duration(30,0,0,0)
This is very helpful, thank you vert much for the help!!
Your welcome,
if it solve your problem, pls mark it as solution for the use of other users.