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

476

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 476 on at

Like (0)

Report
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