Date only calculated field result type not working

(0) Share

Report

Posted on by HansHeintz

674

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:

General Questions

All responses (2)

Answers (0)

ronaldwalcott 3,587 on at

Like (0)

Report

Date only calculated field result type not working

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.
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report
Date only calculated field result type not working

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!