Get data within 1 day

[JennyMilf]

Hello everyone, 

I want to get all the ID base on Register_datetime and Expire_datetime within 1 day. I tried the DATEDIFF function but it doesn't work like the photo below

Can anyone help me? Thanks

Example: 

[vicky_ · Accepted solution]

You need to return 1 value (instead of just filtering a table, which returns multiple lines) - instead of using FILTER... Try: 
IF(DATEDIFF(... etc.) <= 1, 1, BLANK().

That returns 1 when the DATEDIFF condition is True, and then you can use that as a filter.

[JennyMilf]

thank you, it's work!

[JennyMilf]

Thank you for responding, But it seems like I can not use the DATEDIFF function and I don't know why. Do you have any idea? 

[amitchandak · Accepted solution]

@JennyMilf , if you creating a column, you should be able to use

DATEDIFF([Date1], [Date2], day)

If you are creating a measure then try like

countrows(filter(Table, DATEDIFF([Date1], [Date2], day) <=1) )

[vicky_ · Accepted solution]

You need to return 1 value (instead of just filtering a table, which returns multiple lines) - instead of using FILTER... Try: 
IF(DATEDIFF(... etc.) <= 1, 1, BLANK().

That returns 1 when the DATEDIFF condition is True, and then you can use that as a filter.