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

487

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.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Vijay Yelmame VY 487 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); }

Was this reply helpful? Yes No