Forum Discussion

mioani's avatar
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 be...
  • tristaanogre's avatar
    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




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