Question
HCL Technologies
IN
Last activity: 2 Feb 2022 7:04 EST
After run the report, first rows shows the wrong value for one of the column(Days since received)
After run the report, first rows shows the wrong value for one of the column(Days since received)
Ex: one of the column we calculated days (difference between received date and current date).
Received date : 2/1/2022 and Current date : 3/1/2022...The expected result is 1, but it shows 0 and it happened for first row only, remaining rows are calculated as expected.
Is there any solution to fix this?
Mphasis
IN
@ManikandanS1998Usually the date gets stores on the GMT format, just try one comparing the Backend date values. Thanks
Chandan U
HCL Technologies
IN
@ChandanU5252 Thanks for reply, But i already tried by giving GMT manually in my declare expression, its working fine only, my problem is while generating report the first row shows the wrong value. By enable paging option, I'm seeing wrong value on first row of each page
Mphasis
IN
@ManikandanS1998 Whats the Function are we using for "(difference between received date and current date)." Asking just to try replicate in my instance Thanks
Chandan
HCL Technologies
IN
@ChandanU5252 The function is "DifferenceBetweenDays" based on the calendar it will calculate.