Date only calculated field result type not working

(0) Share

Report

Posted on by HansHeintz

711

Hi,

I have a datetimefield in a dataverse table and in my App I want to filter for that field on a specific whole date. So I make a calculated field based on thet datetimefield just resulting in it's value but in a date only format. It is not working and if I inspect the vale for the calculated field for a spec record I get

1/28/2022 1:32 PM, which seems like a datetime value in stead of date only.

If I filter for datefield>condtiondate And datefield<DateAdd(condtiondate,1) I get enormous delays and in de monitor I see many bad requests (strangly this worked quickly before in a previous version of the app) . The result is as expected but the delay is unacceptable for users.

>Edit also using the Text Or Round functions are forbidden for datevalues in formula fields.

How can I address this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi HansHeintz,

I don't think you need to create a separate calculated column to filter the data by date using a datetime column in Dataverse.

Lets assume you are selecting the date using a DatePicker and want filter the data for that particular date. Here's how you can do it -

With( {Records: DVTable}, Filter( Records, DateValue(datefield) = DatePicker1.SelectedDate ) )

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
ronaldwalcott 3,906 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Depending on the number of records in your table you may also have to consider changing your data design and creating a column to contain the indexed date value.

Was this reply helpful? Yes No