Duration (TIME) to close of day (Midnight)

Dean_Axon

I'm trying to find the DURATION based on a time I enter (say 23:30:00) to Midnight (24:00:00 or 00:00:00 as navision Help says).

My Problem is that when I do this:

Duration := 000000T-MyTime;
(Duration := 000000T-23:30:00)
I get -23 hours and 30 minutes

How do I get the difference of 30 minutes with C/AL Code ?!?!!?!?!

Any help would be appreciated, in fact ALL help would be appreciated.

Dakkon

You should use DateTime data types. Try something like the following:

MidNight := CREATEDATETIME(020907D,000000T);
myDuration := MidNight - CURRENTDATETIME;

In the above example, MidNight is just a variable of DateTime. You can of course substitute the 020907D literal with a CALCDATE call or whatever value suits your needs.

kine

  Dur := CREATEDATETIME(020100D,0T)-CREATEDATETIME(010100D,MyTime);

Dakkon

well sure if you want to go and optimize it to one line ;p *grin*
I still like using meaningfull variable names for constant values
Or maybe even define a function TIMETILLMIDNIGHT and drop the code there:)
I guess we all have our individual preferences hehehehe

Dean_Axon

I ended up doing this...

  HourstoMidnight[1]:=235959t-inTime[1];
  HourstoMidnight[1]+=1000;

Not as clean, but functional.

Will try some of these suggestions though