Как найти дату назад

var task03Btn = document.getElementById("task03Btn");
var task03Result = document.getElementById("task03Result");

task03Btn.addEventListener("click", function GetMinusDate(date, days) {
  var CopyDate = new Date(date);
  days = document.getElementById('daysAgo').value;

  CopyDate.setDate(date.getDate() - days);
  return CopyDate.getDate();
  task03Result.innerHTML = `${GetMinusDate(date, days)}<br>`;
});

<table>
  <tr>
    <td> Задача №2. День месяца был N дней назад </td>
    <td>
      <input type="text" id="daysAgo" placeholder="дней" />
      <button id="task03Btn"> Выполнить </button>
    </td>
    <td>
      <div id="task03Result"></div>
    </td>
  </tr>
</table>

задан 11 окт 2020 в 12:37

{$ between.from.format(“dddd”) $}{$ between.from.date() $}{$ between.from.toDate()|date:”MMMM” $}{$ between.from.year() <= 0 ? (between.from.year() – 1) * -1 :
between.from.year() $} года 
{$ century.between.from < 0 ? (century.between.from * -1) + ” век до н. э.” :
century.between.from + ” век н. э.” $}

{$ between.to.format(“dddd”) $}{$ between.to.date() $}{$ between.to.toDate()|date:”MMMM” $}{$ between.to.year() <= 0 ? (between.to.year() – 1) * -1 : between.to.year()
$} года 
{$ century.between.to < 0 ? (century.between.to * -1) + ” век до н.н.” :
century.between.to + ” век н. э.” $}

{$ across.date.format(“dddd”) $}{$ across.date.date() $}{$ across.date.toDate()|date:”MMMM” $}{$ across.date.year() <= 0 ? (across.date.year() – 1) * -1 :
across.date.year() $}
года
{$ century.across.date < 0 ? (century.across.date * -1) + ” век до н. э.” :
century.across.date + ” век н. э.” $}

Прибавить к дате дней

{$ ago.date.format(“dddd”) $}{$ ago.date.date() $}{$ ago.date.toDate()|date:”MMMM” $}{$ ago.date.year() <= 0 ? (ago.date.year() – 1) * -1 : ago.date.year()
$} года
{$ century.ago.date < 0 ? (century.ago.date * -1) + ” век до н. э.” :
century.ago.date + ” век н. э.” $}

Вычесть из даты дней

из
{$ convert.from.name $}
в
{$ convert.to.name $}

сутоксуток

If the current date is 3/12/2015, then I need to get the files from dates 2/12/2015, 3/12/2015, 4/12/2015. Can anyone tell me an idea for how to do it?

<%
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");


Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433/CubeHomeTrans","sa","softex");

Statement statement = con.createStatement() ; 

ResultSet resultset = statement.executeQuery("

select file from tablename
where date >= DATEADD(day, -1, convert(date, GETDATE()))
and date <= DATEADD(day, +1, convert(date, GETDATE()))") ;


while(resultset.next())
{
String datee =resultset.getString("Date");
out.println(datee);
}
}
catch(SQLException ex){
System.out.println("exception--"+ex);

}

%>

This is the query I have done, but it’s erroneous. I need to get the previous date, current date and next date.

Simplest way to get all these dates are as below:-

CURRENT DATE

SELECT DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)

NEXT DAY DATE (Adding 1 to the dateadd parameter for one day ahead)

SELECT DATEADD(day, DATEDIFF(day, 0, GETDATE()), 1)

YESTERDAY DATE (Removing 1 from the datediff parameter for one day back)

SELECT DATEADD(day, DATEDIFF(day, 1, GETDATE()), 0) 

If you go through the link here, you will get an amazing way of explanation for getting date. It will clear your logic and will be useful for future reference too.

Hope that helps you