Conversion of QTP time format (YYYYMMDDHHMMSS)
After looking up a lot of information before, it was written like this:
SendTime = year (sendTime) & right ("00" & month (sendTime), 2) & right ("00" & day (sendTime), 2) & right ("00" & hour (sendTime), 2) & right ("00" & minute (sendTime), 2) & right ("00" & second (sendTime), 2)
But the result of the run is: YYYY- M-DHHMMSS (2012641338), omitting the zero before the month is single digit, and the intended result is 201206041338
Here are the correct results:
Date data is formatted as yyyymmddhhmmss
Function FormatDate (strDate)
FormatDate=year (Cdate (strDate)) & right ("0" & month (Cdate (strDate)), 2) & right ("0" & day (Cdate (strDate)), 2) & right ("0" & hour (Cdate (strDate)), 2) & right ("0" & minute (Cdate (strDate)), 2) & right ("0" & second (Cdate (strDate), 2)
End Function
The result is 201206041338.