Forum Discussion

DainiusA's avatar
DainiusA
Contributor
3 years ago

(aqDateTime["Today"](), "%Y%m%d") -1); problem

TesComplete 14.01 version:   Code: var DateYesterday = (aqConvert["DateTimeToFormatStr"](aqDateTime["Today"](), "%Y%m%d") -1); Log["Message"]("Date inputed: " + (aqConvert["DateTimeToFormatStr"](...
Desktop Testing
Script Tests
Test Results
  • npaisley's avatar
    npaisley
    3 years ago

    Hey DainiusA!

     

    Good news here is that aqDateTime also has a AddDays function that will allow you to add or remove a specific amount of days that will adhere to the calendar. 

     

    For instance, in the code below we create variables that hold Todays date, then we subtract one from it. The AddDays function will roll the time back to the previous month if Todays date is the first of the month.

     

    // script start

    function yesterDay()

     

        var today, yesterdayRaw, yesterdayFormatted;

     

        today = aqDateTime.Today();
        yesterdayRaw = aqDateTime.AddDays(today, -1);
        yesterdayFormatted = aqConvert.DateTimeToFormatStr(yesterdayRaw, "%Y%m%d");

        Log["Message"]("yesterdayFormatted " + (yesterdayFormatted));

    // script end

     

     

    Here are some docs that cover these functions. I hope this helps!

    https://support.smartbear.com/testcomplete/docs/scripting/working-with/dates/javascript.html

    https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqdatetime/adddays.html

     

     

DainiusA's avatar
DainiusA
Contributor

 

Ok this one works until i try to change the format of the date

 

YesterdayDate = aqDateTime["AddDays"](CurrentDate,"%Y%m%d" -1);

 

I get an error Overflow on this one. Maybe I am doing it in some kind of wrong order ?

ebarbera's avatar
ebarbera
Staff
3 years ago

Hi DainiusA  - 

 

I believe this is the code you are looking for : Log["Message"](aqConvert["DateTimeToFormatStr"](YesterdayDate, "%Y%m%d"));

 

Let me know if this helps. 

 

Emma

  • DainiusA's avatar
    DainiusA
    Contributor
    3 years ago

    Not quite. In the Log it shows the format the one I need: But the thing is I need to press buttons one by one in this order on my keypad

     

     

    Sample code without date formatting that works at this moment:

     

    function YeterdayInput ()
    {
    var CurrentDate = aqDateTime.Today();

    // Convert the date/time value to a string and post it to the log
    Today = aqConvert["DateTimeToStr"](CurrentDate);

    // Calculate the yesterday’s date, convert the returned date to a string and post this string to the log
    DateYesterday = aqDateTime["AddDays"](CurrentDate, -1);
    ConvertedYesterdayDate = aqConvert["DateTimeToStr"](DateYesterday);
    for (var i = 0; i < aqString["GetLength"](DateYesterday); i++)
    {
    PressNumber( aqString["GetChar"](DateYesterday, i));
    }
    ClickOk()
    }

    • npaisley's avatar
      npaisley
      Staff
      3 years ago

      Hey DainiusA!

       

      Good news here is that aqDateTime also has a AddDays function that will allow you to add or remove a specific amount of days that will adhere to the calendar. 

       

      For instance, in the code below we create variables that hold Todays date, then we subtract one from it. The AddDays function will roll the time back to the previous month if Todays date is the first of the month.

       

      // script start

      function yesterDay()

       

          var today, yesterdayRaw, yesterdayFormatted;

       

          today = aqDateTime.Today();
          yesterdayRaw = aqDateTime.AddDays(today, -1);
          yesterdayFormatted = aqConvert.DateTimeToFormatStr(yesterdayRaw, "%Y%m%d");

          Log["Message"]("yesterdayFormatted " + (yesterdayFormatted));

      // script end

       

       

      Here are some docs that cover these functions. I hope this helps!

      https://support.smartbear.com/testcomplete/docs/scripting/working-with/dates/javascript.html

      https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqdatetime/adddays.html

       

       

      • DainiusA's avatar
        DainiusA
        Contributor
        3 years ago

        Thank you npaisley 

         

        This was exactly I was looking for !

        Really appreciate all of you help.