Forum Discussion

mioani's avatar
mioani
Occasional Contributor
6 years ago

Get the date of next Sunday

Hello all,

 

I want to get the date of the next Sunday, of every week to be entered in a specific field. I have tried aqConvert.DateTimeToFormatStr(aqDateTime.AddDays(7), '%d.%m.%Y') as Sunday being the 7th day of the week but my syntax is wrong. Since I am very new at this, any help would be much appreciated.

 

Thank you!

  • tristaanogre's avatar
    tristaanogre
    6 years ago

    Then your code is going to need to be longer than single line.  

     

    You're going to need to know

     

    1) What the current day of the week is

    2) How many days until Sunday that is

     

    So...

     

    function getNextSunday(currentDate){

    var currentDOW = aqDateTime.GetDayOfWeek(currentDate);
    var daysToAdd = 8-currentDOW;
    return aqDateTime.AddDays(currentDate, daysToAdd);

}
  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    6 years ago

    AddDays requires a parameter indicating the date to add days to.  Try

     

    aqConvert.DateTimeToFormatStr(aqDateTime.AddDays(aqDateTime.Now(),7), '%d.%m.%Y')

    • mioani's avatar
      mioani
      Occasional Contributor
      6 years ago

      Thank you so much for your reply.

      What i'm trying to do here is to get the date of next Sunday, no matter what day it is of the week. i.e tomorrow if i play the test again, the date fetched to be next Sunday.

      The solution of your reply will give me the seventh day from today any day, and I want the date by default to be always Sunday, without updating my test.

      Thank you again

      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor
        6 years ago

        Then your code is going to need to be longer than single line.  

         

        You're going to need to know

         

        1) What the current day of the week is

        2) How many days until Sunday that is

         

        So...

         

        function getNextSunday(currentDate){

    var currentDOW = aqDateTime.GetDayOfWeek(currentDate);
    var daysToAdd = 8-currentDOW;
    return aqDateTime.AddDays(currentDate, daysToAdd);

}