Filtering based on DateTime

[RaSa]

I´m filtering the data from a dataverse based on dates and times. Everything should be explain in the picture. Please help if you have a idea how to fix that.

[cwebb365 · Accepted solution]

What are StartDateTime and EndDateTime? Variables? what types? You may just need to use those values. If they are Text then both should be DateTimeValue().  I beleive you can do that without delegation issues these days. In the past you would want to use the With() function to convert the values into tempory variables and use those variables for the comparison but I don't think that's needed anymore. 

What error are you getting as to why it's not working? 

[RaSa]

Hi @cwebb365 , StartDateTime and EndDateTime are DateTime variables.

The column in the dataverse is DateTime type as well with Time Independent behavior.

If I use only variable in the filter:

cr1fc_activitystartdate=StartDateTime

or

cr1fc_activitystartdate=DateTimeValue(StartDateTime)

I´m not getting any data.

I´m sure the problem is with a DateTime filtering since without those two filters the code works alright. 

Does it somehow matter that in the variable there are seconds as well and in Dataverse there are not ? Or maybe comma between date and time ?

[cwebb365]

It's either seconds or timezone conversion issues, when using equals times are harder to work with. I always try to put two labels on a screen somewhere and put both values on them then compare to make sure timezone isn't a factor. You can always wrap the dataverse value into a datetime() as well so it might equal that way. 

DateTimeValue(cr1fc_activitystartdate) = StartDateTime

If that don't work, get them both on a label and compare and make sure they are the same values, then we can go from there converting to what we need.