Date Format String

Questions
,
1

Hello All,
I have a problem about the date format and I want to change the date format.
How to change the date format from “10 may 2024” to “2024-05-10”.

image
image1197×705 37.1 KB

Information on your n8n setup

  • n8n version:1.39.1
  • Database (default: Postgress):
  • n8n EXECUTIONS_PROCESS setting (default: own, main): main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system:Linux
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

@Jackon_Spray , use the expression {{ DateTime.fromFormat($json.date, 'd LLLL y').toFormat('yyyy-MM-dd') }}.

I assume the month is the full name, that is “april” and not “apr”. If the three-latter month is used then replace LLLL with LLL.

4

it works thank you