yesterday date macro in Confluence

Gwenaël GRALL

Hello,

I would to get the yesterday date from currentDate.

I need to get a specific hours

With Confluence's macro  I try to request on Jira

The request is like : project = "xx" AND created >= "2019-03-04 18:00" AND created <= "2019-03-05 18:00"

So I wrote this but $yesterday is missing:

## @param Project:title=project|type=string|required=true|desc=Key
#set($day2 = $action.dateFormatter.formatGivenString("yyyy-MM-dd 18:00", $content.currentDate))
  <ac:macro ac:name="jiraissues">
    <ac:parameter ac:name="title">;All Resolved Issues</ac:parameter>
    <ac:parameter ac:name="renderMode">static</ac:parameter>
    <ac:parameter ac:name="columns">Key,Created,Updated,Assignee,Status</ac:parameter>
    <ac:parameter ac:name="url">http://url.fr:8080/sr/jira.issueviews:searchrequest-rss/temp/SearchRequest.xml?jqlQuery=project+=+"$paramProject"+AND+created+>=+"$day2"&lt;/ac:parameter&gt;
  </ac:macro>

Thanks for help

Diego_88dj6o

Hello there Gwenaël! Great to have you here.

For you to get the yesterday date, we will need to set a variable with the calendar type and then subtract one with the .add method from the date type:

## @noparams
#set ($date=$action.dateFormatter.calendar)
$date.setTime($content.getCurrentDate())
$date.add(6, -1)
yesterday $action.dateFormatter.formatGivenString("yyyy-MM-dd", $date.time) <br>

You will be able to find more details on the add() method here:

Class Calendar - Field Manipulation

With dateFormatter you should be able to format the date as you see fit for your need. Here are some details on dateFormatter:

Oracle - dateFormatter

Let me know if this piece of information helps you!