Building model-driven apps with Microsoft Datav...

DateDiff

(0) Share

Report

Posted on by CU20081449-2

Hi guys, please i am having issues with creating table of Observed with this code DateDiff('Date Observed',Now(),TimeUnit.Days). I have been on this issue for days. Please help

Categories:

General Discussion

Capture.JPG

All responses (3)

Answers (0)

Suggested answer

DJ-27081057-0 2 on at

Like (1)

Report

DateDiff

DateDiff('Date Observed',UTCToday(),TimeUnit.Days)

Replace with UTC Today, however as per description it seems incorrect in the video.

Field is Reporting Days

How long it took to first report the issue in days

It should have been date observed - created on date in days
Suggested answer

CU25081117-0 2 on at

Like (2)

Report

DateDiff

I was having same issue then I used this:

//

DateDiff('Date Observed',UTCNow(),TimeUnit.Days)
Suggested answer

Glynnryan 24 on at

Like (1)

Report

DateDiff

To get this working, you can use the formula:

DateDiff('Date Observed',UTCNow(),TimeUnit.Days)

Alternatively, you could try changing the table column for Date Observed to a Date and Time column and not just Date Only. However, this could have an impact on other app functions later on.