Working with time

Fisherman · 2006-08-30

I'm looking for the equivalent, or similar, functions to CALCDATE in order to manipulate either a DATETIME or TIME. Is there anything in C/AL to do so? I've searched for "Add Date" and "Add Time", but I've not turned up anything yet. The docs aren't much help. Under TIME, it just has a definition of the TIME type, or the TIME function. DateTime has even less info...

Alex_Chow · 2006-08-30

Time is stored as integer in Navision. So 100000 translates into 1 minute.

You can use:
MyTime := TIME + 100000
to add one minute to the current time.

David_Cox · 2006-08-30

You can create a vaiable or field of type DateTime and then look at the globals help:

This one looks about right
DateTime := CREATEDATETIME(NewDate, NewTime);

I should think you could calculate the difference between two date times and just add it to the Datetime field.

I think its something like this but it was several years ago:
DateDiff := ((ToDate+ToTime)-(FromDate+FromTime));

Others
Date := DT2DATE(Datetime);

Time := DT2TIME(Datetime);

Sorry Not read the original post properly Ignore this reply

kine · 2006-08-31

No, there are not such a functions, but you can do DATETIME + Duration etc.

David_Cox · 2006-08-31

Maybe if you say what you are trying to do in more detail, we may be able to help more

Alex_Chow · 2006-08-31

Haha... He posts one and gets a bunch of replies that may not even be what he needs.

ZMike · 2007-01-17

deadlizard wrote:

Time is stored as integer in Navision. So 100000 translates into 1 minute.

You can use:
MyTime := TIME + 100000
to add one minute to the current time.

I tried your solution... It didn't work... #-o

The right solution is:
MyTime := TIME + 600000 to add one minute to the current time.

Resuming:
1 min - 600000
1 hour - 3600000
12 hours 43200000
.....

Mbad · 2007-01-17

And here i thought it was milliseconds... Need new calculous apparently.

Howdy, Stranger!

Quick Links

Categories

Working with time

Comments