Skip to Content
avatar image
Former Member

$controller.DateTimeUtils.DateNow() returns emply rows

Hi All,

I have created a custom OVS using SADL Query.

At OVS output, I am displaying ID, Description, StartDateTime, EndDateTime and TodayDateTime.

Except TodayDateTime others are being fetched directly from SADL Query.

TodayDateTime field is being populated from script


Basically purpose of this is to validate records which are valid on current date.

The script code is as below:

result = $controller.DateTimeUtils.dateNow();
for i in 0..($data.Items.RowCount)
$data.Items.Get(i).TodayDateTime = $controller.DateTimeUtils.dateNow();
if($controller.DateTimeUtils.dateSub($data.Items.Get(i).EndDateTime,$data.TodayDate) < 0)
$data.Items.Get(i).TodayDateTime = $controller.DateTimeUtils.dateNow();
if($controller.DateTimeUtils.dateSub($data.TodayDate,$data.Items.Get(i).StartDateTime) < 0)

But getting blank value for TodayDateTime in the output.

Please guide,



kpvcr.png (11.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers