Convert datetime to date in calculated field

(0) Share

Report

Posted on by ShaqAX

709

Hi,

How to convert a date time field to date format only in calculated field of data entity ?

I want to add new field for my data entity. It is a date from CreatedDateTime field, but I don;t need the time, only the date.

After create the View method and then add it to a new field of my data entity, with DateUnmappedField, I've put the EDT in the field property to TransDate, but the result still with the time. Guess I need to convert it first in my View, but I don;t know how.

Thanks,

I have the same question (0)

All responses (2)

Answers (1)

WillWU 22,361 on at

Like (0)

Report

Hi ShaqAX,

You could use DatetimeUtil::Date(utcdatetime) to return a Date.

By the way, why use a computed field? In your case, a virtual field may be more appropriate for you.

docs.microsoft.com/.../data-entity-computed-columns-virtual-fields

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (2)

Report

Use SysComputedCokumn::fromUtcDateToDate(). For example, see validFrom() method in WrkCtrAbilityPersonTitle view.

DatetimeUtil::date() can't be used in computed columns.

Was this reply helpful? Yes No