computed column of view - How to return date difference in days between todays date and record creation datetime

(0) Share

Report

Posted on by Vijay Yelmame VY

489

HI All,
I am implementing a requirement where I want to return date difference between creation date time and today's date. have tried like below but not getting expected result. Please suggest the approch.

 private static server str compColumnApprovalDays()
    {
      

        #define.CompView(AllPOLinesView)
        #define.CompDS(PurchLine)
        #define.FieldCreatedDateTime("CreatedDateTime")

        str todayDate = strFmt("%1", DateTimeUtil::getToday(DateTimeUtil::getUserPreferredTimeZone()));

        str fromDate =  SysComputedColumn::returnField(tableStr(#CompView), identifierStr(#CompDS), fieldStr(#CompDS, #FieldCreatedDateTime));

        str test = SysComputedColumn::getDateDiff(fromDate,todayDate);

      

        return test;
    }

in DB i am able to see the values as shown below.

All responses (1)

Answers (1)

Verified answer

Vijay Yelmame VY 489 on at

Like (0)

Report
Copy link

Link copied!
This is resolved. Please don't invest your time.

private static server str compColumnApprovalDays() { return SysComputedColumn::getDateDiff( SysComputedColumn::returnField(tableStr(AllPOLinesView), identifierStr(PurchLine), fieldId2name(tableNum(PurchLine),fieldNum(PurchLine, CreatedDateTime))), SysComputedColumn::getCurrentUtcDate(), SysComputedColumnDatePart::Day); }