how to know minute difference on nav 2015 with report builder

yonhantdaenta89@hotmail.com

Hi Expert.

I am having difficulties on showing minutes difference on report builder. if I have A as datetime value and B and datetime value. what should I use to see the minutes difference on report

many thanks,

yonhantdaenta89@hotmail.com

Kishorm wrote: »

Ah, it could be because the DateTime field(s) are blank, try changing the code to...

IF (FromDT = 0DT) OR (ToDT = 0DT) THEN
  MinsDiff := 0
ELSE
  MinsDiff := ROUND((ToDT - FromDT) / 60000,1);

this code work.

thanks, @Kishorm

Kishorm

You should calculate that in NAV and then include the value in the dataset, e.g. Something like...

MinsDiff := (ToDT - FromDT) / 60000;

yonhantdaenta89@hotmail.com

Hi @Kishorm : I tried that but the report tells me that the date is not valid. I describe MinsDiff as time and integer also not working.

any ideas?

thanks,

mohana_cse06

diff variable should be integer and from and to values should be date time type..

Kishorm

@yonhantdaenta89@hotmail.com - MinsDiff should be a Decimal for the above code.

If you want whole number of minutes then make it an Integer and change the code slightly...

MinsDiff := ROUND((ToDT - FromDT) / 60000,1);

Also, make sure you are not trying to format the MinsDiff as a Date in your RDLC report layout (Text Box Properties --> Number) - leave this as Default

yonhantdaenta89@hotmail.com

Kishorm wrote: »

@yonhantdaenta89@hotmail.com - MinsDiff should be a Decimal for the above code.

If you want whole number of minutes then make it an Integer and change the code slightly...

MinsDiff := ROUND((ToDT - FromDT) / 60000,1);

Also, make sure you are not trying to format the MinsDiff as a Date in your RDLC report layout (Text Box Properties --> Number) - leave this as Default

tried this one, also same error

Kishorm

Ah, it could be because the DateTime field(s) are blank, try changing the code to...

IF (FromDT = 0DT) OR (ToDT = 0DT) THEN
  MinsDiff := 0
ELSE
  MinsDiff := ROUND((ToDT - FromDT) / 60000,1);

yonhantdaenta89@hotmail.com

Kishorm wrote: »

Ah, it could be because the DateTime field(s) are blank, try changing the code to...

IF (FromDT = 0DT) OR (ToDT = 0DT) THEN
  MinsDiff := 0
ELSE
  MinsDiff := ROUND((ToDT - FromDT) / 60000,1);

this code work.

thanks, @Kishorm

Kishorm

Great, in that case please mark my post above as having answered the question (you should have a "Did this answer your question YES / NO") option.