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

438

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

Like (0)

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

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); }