<< Click to Display Table of Contents >> Navigation:  General interface > 3.8: Dates

 

Dates are defined on a continuous timeline

 

Dates are recoded in AMS with the full time information: the day, the hour and minutes (and seconds). This assertion seams to be obvious but it leads to consequences that are not so obvious:

 

When you write a date, AMS store it with its full time information. If the hours and minutes was omitted, AMS assumes the hours and minutes was 00:00

For example "12/03/2012" is interpreted as being "12/03/2012 00:00".

 

The most common misuse of this rule is when a user requests some calculation during a period or time, or when selecting data based on dates. For example, to compute something for the months of April and May 2012, the date range is not 01/04/2012 ->   31/05/2012 because this range will be interpreted as meaning 01/04/2012 00:00 ->   31/05/2012 00:00 (the full day of 31/05/2012 will be outside the selected range).

In this case, the correct range is         01/04/2012                ->   01/06/2012

or                                01/04/2012 00:00         ->   31/05/2012 23:59

 

 

Date format

 

Except when the date format is clearly specified (ex: DD/MM/YYYY), the date format used by AMS is the one configured on the client computer control panel, date format settings (as defined in MS Windows).