Date formatting

Mariusthvdb · April 16, 2019, 9:09am

you need to add the entity_id of the changing sensor. depending on which you have defined in your config, add:

  - platform: template
    sensors:
      date_long: 
        friendly_name: 'Datum'
        entity_id: sensor.date, # or sensor.date_time, or sensor.time_date
        value_template: >
          {% set months = ["januar", "februar", "marec", "april", "maj", "jun", "jul", "august", "september", "oktober", "november", "december"] %}
          {% set month = months[now().strftime('%m') | int -1] %}  
          {{ now().strftime('%d') + ' ' + month + ' '+ now().strftime('%Y') }}

angeltonio · December 29, 2019, 4:36pm

Hello how you add the icons??..

browetd · December 29, 2019, 4:48pm

after the line containing “value_template:”, add “icon_template: mdi:weather-sunset-down” for example… You can also add some customization in the “customize.yaml” file for the corresponding sensor.

Alwin_Hummels · February 27, 2020, 6:12pm

Can someone help me to localize this?

  life360_naam_lastseen:
    friendly_name: "Naam voor het laatst gezien"
    value_template: "{{ as_timestamp(state_attr('device_tracker.naam', 'last_seen')) | timestamp_custom('%A om %-H:%M') }}"

  life360_naam_since:
    friendly_name: "Naam's Locatie Sinds"
    value_template: "{{ as_timestamp(state_attr('device_tracker.naam', 'at_loc_since')) | timestamp_custom('%A om %-H:%M') }}"

Outcome now is Englisch dayname with correct time, but I want the Dayname in Dutch so any help is welcome

petro · February 27, 2020, 6:16pm

You can’t use %A then, the python version that’s used is English. e.g. all items passed through strftime will be in English. You’re better off making a map like what is outlined above.

Alwin_Hummels · February 27, 2020, 6:19pm

Thank for the quick reply, but I’m just a noob. Can you please give me a hint how to do?

petro · February 27, 2020, 6:22pm

Alwin_Hummels · February 27, 2020, 6:39pm

I already have this

  life360_name_since:
    friendly_name: "Naam's Locatie Sinds"
    value_template: >
    {%- set wdays = ["maandag", "dinsdag", "woensdag", "donderdag", "vrijdag", "zaterdag", "zondag"]  %}
    {{ as_timestamp(state_attr('device_tracker.name', 'at_loc_since')) | timestamp_custom(wdays[now().weekday()] + (' om %H:%M')) }}

But this gives me not the correct day value and a headache what do I miss/wrong?

Maybe I’m too stupid but I appreciate any help.
I really need to learn templating please point me the right way.

Alwin_Hummels · February 28, 2020, 12:49pm

Fixed with help on a Dutch channel.

{%- set tracker_timestamp = as_timestamp(state_attr('device_tracker.name', 'at_loc_since')) %}
{%- set wdays = ["zondag", "maandag", "dinsdag", "woensdag", "donderdag", "vrijdag", "zaterdag"] %}
{%- set wday =  tracker_timestamp | timestamp_custom('%w') | int %}
{{ tracker_timestamp | timestamp_custom(wdays[wday] + ' om %H:%M') }}

_LF · April 19, 2020, 9:56am

Hi Alwin, is this also possible in combination with strftime?

I have this:

  - platform: afvalinfo
    resources:
      - pbd
      - gft
      - restafval
      - papier
      - trash_type_today
    city: !secret CTY
    postcode: !secret PSC
    streetnumber: !secret NMB
    dateformat: '%a %d %B'
    timespanindays: 365

afval
I really like to change the %a (weekday) from english to dutch. Can you help me with this?

petro · April 19, 2020, 11:14am

strftime uses pythons set language which will always be english. You’ll have to take those values and pass them through a template sensor. For that, it would probably be best to take your current sensors and change them all to numerical values, then you can you strptime to convert them into your values.

  - platform: afvalinfo
    resources:
      - pbd
      - gft
      - restafval
      - papier
      - trash_type_today
    city: !secret CTY
    postcode: !secret PSC
    streetnumber: !secret NMB
    dateformat: '%d-%m-%Y'
    timespanindays: 365

sensor:
- platform: template
  sensors:
    paper_pickup_day:
      value_template: >
        {% set current = strptime(states('sensor.papier'), '%d-%m-%Y') %}
        {%- set days = ["zondag", "maandag", "dinsdag", "woensdag", "donderdag", "vrijdag", "zaterdag"] %}
        {{ current | timestamp_custom(days[current.weekday()] + ' %d %B') }}

Flo.C · May 27, 2020, 10:20pm

Hi guys,

i´m actually stealing a theme and this has a cool Markdown card which shows the current date. My goal is to have it in the following format (in german )

“Mittwoch, der 28. Mai”

I have no idea about templating and where to put stuff so maybe one of you could help me on this. THis is how the code currently looks:

- type: markdown
        content: |
          {% if now().month in (1,) %}
          ## {{ now().day }} Januar
          {% elif now().month in (2,) %}
          ## {{ now().day }} Februar 
          {% elif now().month in (3,) %}
          ## {{ now().day }} März 
          {% elif now().month in (4,) %}
          ## {{ now().day }} April 
          {% elif now().month in (5,) %}
          ## {{ now().day }} Mai 
          {% elif now().month in (6,) %}
          ## {{ now().day }} Juni 
          {% elif now().month in (7,) %}
          ## {{ now().day }} Juli 
          {% elif now().month in (8,) %}
          ## {{ now().day }} August 
          {% elif now().month in (9,) %}
          ## {{ now().day }} September
          {% elif now().month in (10,) %}
          ## {{ now().day }} Oktober 
          {% elif now().month in (11,) %}
          ## {{ now().day }} November 
          {% elif now().month in (12,) %}
          ## {{ now().day }} December 
          {% endif %}
        style: |
          ha-card {
             margin: 12px 14px -5px 14px;
             box-shadow: none;
             --paper-card-background-color: rgba(0, 0, 0, 0.0)
           }
           h2 {
             font-size: 18px;
             font-weight: 400;
             padding-left: 10px;
             border-left: 3px solid rgba(81, 134, 236);
           }

Thanks a lot in advance.

Cavekeeper · November 18, 2020, 3:48pm

I read this post carefully. However, I do not get my problem solved. In lovelace.ui the timestamp is displayed as an invalid date:

The date is displayed correctly in the template engine:
Template engine Result type: string

platform: template
sensors:
bwm_flur_last_motion:
friendly_name: “BWM Flur Letzte Bewegung”
device_class: timestamp
value_template: “18.11.2020 16:07”

Template Code:

- platform: template
  sensors:
    bwm_flur_last_motion:
      friendly_name: "BWM Flur Letzte Bewegung"
      device_class: timestamp
      value_template: "{{ as_timestamp(state_attr('automation.bwm_flur', 'last_triggered')) | timestamp_custom('%d.%m.%Y %H:%M') }}"

There must be something wrong with the timestamp_custom. Does anyone have a solution here?

petro · November 18, 2020, 5:12pm

Use this instead

"{{ as_timestamp(state_attr('automation.bwm_flur', 'last_triggered')) | timestamp_custom('%Y.%m.%dT%H:%M:%S') }}"

But you can also be super lazy and just output the last_triggered and it should work

"{{ state_attr('automation.bwm_flur', 'last_triggered') }}"

Cavekeeper · November 18, 2020, 5:32pm

Sorry, but
the first example does not fix the problem. The message “Invalid date” remains.
The second example gives me not the required format. Last seen info, i.e. 45 minutes, instead of the fixed datum: %d.%m.%Y %H:%M

BlazSLO · January 3, 2021, 7:27pm

Hello all,

call me stup** but I dont know, how to change date format from YYYY-mm-dd to dd-mm-YYYY?

I`m using simple time_date sensor platform:

sensor:
  - platform: time_date
    display_options:
      - 'time'
      - 'date'
      - 'date_time'
      - 'date_time_utc'
      - 'date_time_iso'
      - 'time_date'
      - 'time_utc'
      - 'beat'

Many thanks for help!

Aviatorpaal · July 27, 2022, 11:43am

Hey! Add this to your sensors.yaml file (I suggest you create one if you don´t use it, it cleans up your configuration.yaml file significantly!):

# Day, month and YEAR, Norwegian format
- platform: template
  sensors:
    date_full_norwegian_format:
      friendly_name: "Full date formatted for Norwegian locale"
      value_template: "{{ as_timestamp(states('sensor.date_time_iso')) | timestamp_custom('%d %m %Y ') }}"
      icon_template: mdi:calendar-blank-outline

rr19-hub · September 7, 2022, 10:13am

I want to output a sensor value in a different formatting for a notification. I get under sensor.washer_remaining_program_time a value like 2022-09-07T12:48:33+00:00 and I don`t manage to extract the time. So for example 12:48.
Is this possible or do I have to create an extra sensor for this?

janiv · October 13, 2022, 10:23am

I have a Mushroom Title card, and I’m using:

secondary: Next {{states(‘sensor.jewish_calendar_upcoming_shabbat_candle_lighting’)}}

How do I change the format inline?
Thanks

rtv · March 18, 2024, 2:10pm

You can use a template (or put it into a helper):

{{ as_timestamp(states("sensor.washer_remaining_program_time")) | timestamp_custom("%H:%M") }}