Time import from excel

Hi ,

i try to import time in ax table through excel

i use following code

table_field_name = str2time(cells.item(i,1).value().bstr())

but in table update ‘?’ (question mark)

second i use

table_field_name = cells.item(i,1).value().time()

but in table update 00:00:00

suggest how to import time through excel

U can refer to this job and based on ur Input paremeters, use the related Function

static void any2DateExample(Args _args)
{
    date myDate;
    str s;   
    int i;
    ;

    s = "2010 6 17"; // A string object, of yyyy mm dd.
    myDate = any2Date(s);
    Global::info(strFmt("%1  is output, from input of \"2010 6 17\"", myDate));

    i = 40361; // An int object, which represents the number of days from 1900/01/01.
    myDate = any2Date(i);
    Global::info(strFmt("%1  is output, from input of 40361", myDate));
}

/**** Infolog display.
Message (04:44:15 pm)
6/17/2010 is output, from input of "2010 6 17"
7/4/2010 is output, from input of 40361
****/

HI

Thanks to reply

but i make class and import that value from excel so how to use this class