Name

c_CONVDATE — Function to convert dates from AAAAMMJJhhmm format to Excel numerical format and vice-versa

Calling Sequence

ConvSerie = c_CONVDATE(ConvType,InputSerie)

Parameters

ConvType

Conversion type

0 = From calendar type (AAAAMMJJHHmm) to Excel numerical type (1 unit = 1 day, 1 = 1/1/1900 00:00)

0 = From Excel numerical type to calendar type

InputSerie

Serie of dates to convert

ConvSerie

Converted dates

Description

  • WARNING : This function is written in C language and interfaced with SCILAB (HYDROGR.dll).

  • This function takes care of bi-sextile years.

Examples

   D1a = [199312090222;199809180035;193711231322;199009090005;199808082225];
   D1b = [34312.09861;36056.02431;13842.55694;33125.00347;36015.93403];
   
   D2a = c_CONVDATE(0,D1a);
   D2b = c_CONVDATE(1,D1b);   

  

Authors

Julien Lerat

CEMAGREF Antony, HBAN Unit, julien.lerat@cemagref.fr