Forum Discussion

royd's avatar
royd
Regular Contributor
8 years ago

aqDateTime.Today() - date format problem.

I am getting an error while creating a new patient. The patient admission date is a month/two into the future. The admission date format calls for mm/dd/yyyy. aqDateTime.Today() produces mm/dd/yy + t...
shankar_r's avatar
shankar_r
Community Hero
8 years ago

If you want 4 digit year then you have to provide %Y instead of %y.

 

var currentDate = aqDateTime.Today();
var dOAdmission = aqDateTime.AddMonths(currentDate, 2);
Log.Message("Today is" + aqConvert.DateTimeToFormatStr(dOAdmission, " %m/%d/%Y"));

Output[highlighted in Green] is Today is 06/24/2017 17:24:39 Normal

 

And for more specifiers. https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqdatetime/date-and-time-format-specifiers.html

  • royd's avatar
    royd
    Regular Contributor
    8 years ago

    Hi Shankar

     

    Thanks for your reply, the funny thing is I tried %yy thinking that will add four digits (before posting here), I did not see any documentation on y and Y! It does work! Thanks for the link to "Date and Time Format Specifiers".

     

    But now I have a different issue! The date is 06/24/2017, but TestComplete is entering  06/24/201 ! I have already sent an email to the Devs, thinking it may be an issue on their end (not heard from them yet). Could it be an issue with TestComplete, how it is interacting with the field? See the screen capture, please.

     

     

    robert, Thanks for pointing out my oversight! :) I know when coping log message, it does copy the time stamp! Going through documentation, found out Today method does not contain time stamp, so when I time (when pasted the log), and did not realize that it came from log, not part of actual date!

     

    Any idea, why the last digit is seen as 11th. digit by TestComplete and truncated?

     

    Thank you both for your valuable time, I really appreciate it.

     

    Dave

    • tristaanogre's avatar
      tristaanogre
      Esteemed Contributor
      8 years ago

      See my commentary in the screenshot

       

       

      • royd's avatar
        royd
        Regular Contributor
        8 years ago

        Yay! Thanks to you, I found my problem! There was a space leading %m/%d/%Y as:

         

        var addmissionD = aqConvert.DateTimeToFormatStr(dOAdmission, " %m/%d/%Y");

        Thank you! :D

    • shankar_r's avatar
      shankar_r
      Community Hero
      8 years ago

      I guess ' 06/24/201' value is prefixed with a space. Do a trim before entering the data and then see what happens.