Forum Discussion

SamuraiJack's avatar
SamuraiJack
Contributor
15 years ago

Best way to convert date mm/dd/yyyy from table data to yyyy-mm-dd in VBScript?

Trying to reconcile the display of data in a web table to the same data from a DB2 DB.  Unfortunately my company has no formatting continuity. Table dates are in the mm/dd/yyyy format, and of c...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
15 years ago
Have you tried utilizing aqConvert? 



procedure TestDataConvert;



var

    MyDateString;

    MyDateDateTime;



begin

MyDateString := '04/01/2010';

MyDateDateTime := aqConvert.StrToDateTime(MyDateString);

MyDateString := aqConvert.DateTimeToFormatStr(MyDateDateTime, '%Y-%m-%d');

Log.Message(MyDateSTring);



end;