Need formula to return the date of the first day of the month

I use $today() to get today’s date. Is there a similar formula that returns the first day of the month, for exemple 01-01-2024T00:00:00-3:00?

Information on your n8n setup

  • n8n version: 1.22.6
  • Database (default: SQLite): sqlite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: Ubuntu

I guess this is what you are looking for:
image

{{ $today.beginningOf(‘month’) }}

2 Likes

I didn’t even know that was a thing, Nice find :slight_smile:

1 Like