Gold ⭐️

Solved

How to derive yesterday's date using now expression

1 reply
2650 views
Translate All

Currently i am using ${now():format("yyyyMMdd")} to extract today's date and passing it to next flow. But i would need Yesterday's and day before's date also in similar way. How can i achieve this.

Appreciate quick response on this.

Apache NiFi

stevenmatisonAnswer

Platinum ⭐️⭐️

@Gubbi The solution here is a now minute 24 hours:

Yesterday:

${now():minus(86400000):format('MM-dd-yyyy hh:mm:ss') }

Day Before Yesterday:

${now():minus(86400000):minus(86400000):format('MM-dd-yyyy hh:mm:ss') }

stevenmatisonAnswer

Platinum ⭐️⭐️

@Gubbi The solution here is a now minute 24 hours:

Yesterday:

${now():minus(86400000):format('MM-dd-yyyy hh:mm:ss') }

Day Before Yesterday:

${now():minus(86400000):minus(86400000):format('MM-dd-yyyy hh:mm:ss') }

Translate