Convert date and time template

Configuration
14

I have a sensor which reports rain at e.g. 16:25 (HH:MM). I want to compare this with equal or less than states(‘sensor.time’) + 20 minutes, before retracting my sunblinds. I take it that in order to accomplish this, I first have to make a unix timestamp of both and here is where I get stuck. Any suggestions?

15

Ignore my request. I was too quick. On this excellent forum and thanks to petro, I found the solution: How to trigger automation BEFORE set time?

16

How can I change the Sun, Mon, …, Sat to German spelling?

Do I need to add “(de_DE)” somewhere in the code next to “%a”?

value_template: >
          {{ as_timestamp(now()) | timestamp_custom('%a %d.%m') }}

Or do I need to add “(de_DE)” in generall settings?

17

You can’t change the ‘under the hood language’. You’ll have to create a map that links the english to German.

18

And how can I create a translation map?

I tried with

{% set days = ["Mo ", "Di ", "Mi ", "Do ", "Fr ", "Sa ", "So "]  %}

Full Code:

  - platform: template
    sensors:
      date2:
        friendly_name: "Datum"
        entity_id: sensor.time
        value_template: >
          {{ as_timestamp(now()) | timestamp_custom('%a %d.%m') }}
          {% set days = ["Mo ", "Di ", "Mi ", "Do ", "Fr ", "Sa ", "So "]  %}
        icon_template: mdi:calendar-range

Or do you mean to use the replace function? Like for example:

replace("Thu", "Do")
19

see this post

20

The config check says: data_template is an invalid option for sensor.template

Do I need to create a service dir this? If so, what service?

  - platform: template
    sensors:
      date2:
        friendly_name: "Datum"
        entity_id: sensor.time
        value_template: >
          {{ as_timestamp(now()) | timestamp_custom('%a %d.%m') }}
        data_template:
          entity_id: sensor.time
          message: >
            {% set days = ["Mo ", "Di ", "Mi ", "Do ", "Fr ", "Sa ", "So "] %}
        icon_template: mdi:calendar-range
21

You don’t need a data template, just the value template. Since now() has a weekday() method, you can use that to directly map into a list of abbreviated localized weekday names:

  # Abbr. localized date: Fr 31.07.
  - platform: template
    sensors:
      date2:
        friendly_name: "Datum"
        entity_id: sensor.time
        value_template: >
          {% set days = ['Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa', 'So'] %}
          {{ now().timestamp() | timestamp_custom(days[now().weekday()] ~ ' %d.%m.') }}
        icon_template: mdi:calendar-range

We simply prepend the mapped localized day name to the custom timestamp here.

The weekday() method of a Python date or datetime object returns the day of the week as an integer, where Monday is 0 and Sunday is 6. Thus, it can be easily used as a list index for the days list (lists start with index 0).

Here’s a little challenge: Try to rewrite the above so it returns the abbreviated German weekdays plus a German month name, like Fr 31. Juli.

Hints:

  • Set up a list called months with the German month names.
  • now() also has an instance attribute called month → now().month. It returns the month numbers 1–12.
  • Remember, list indexes start at zero.
  • The ~ operator in Jinja (the templating engine) concatenates strings, converting values to type string on the fly.

Have fun!

Edit: Strictly speaking, it is not necessary to update a date info every minute, as we do by specifying sensor.time as entity ID to watch.

So if you have sensor.date defined, use that instead. It will update only once per day, at midnight. This will save another few of the precious CPU cycles … :slight_smile:

2 Likes
23

Hey so i tried it and got this:

date2:
        friendly_name: "Datum mit Monat"
        value_template: >
          {% set months = ['Januar', 'Februar', 'März', 'April', 'Mai', 'Juni', 'Juli', 'August', 'September', 'Oktober', 'November', 'Dezember'] %}
          {{ now().strftime (' %d'), now().timestamp() | timestamp_custom(months[now().month] ~ ' %Y') }}

The problem is it gives me the wrong Month (1 Month ahead) and there are also brackets.
(‘22’,‘Dezember 2020’)
Do you know any Solutions?
I’m new to HomeAssistant and have no idea how to solve it.
Kind regards
Hannes

24

change to

          {% set months = ['Januar', 'Februar', 'März', 'April', 'Mai', 'Juni', 'Juli', 'August', 'September', 'Oktober', 'November', 'Dezember'] %}
          {{ now().strftime('%d') ~ ', ' ~ months[now().month-1] ~ now().timestamp() | timestamp_custom(' %Y') }}

or

          {% set months = ['Januar', 'Februar', 'März', 'April', 'Mai', 'Juni', 'Juli', 'August', 'September', 'Oktober', 'November', 'Dezember'] %}
          {{ (now().timestamp() | timestamp_custom('%d, # %Y')).replace('#', months[now().month-1]) }}
1 Like
25

Ah ok thank you.

26

You Sir are THE timestamp template guru!! With the above info I was able to template my lock log sensors’ dates and times!

1 Like
27

Hi all,

i search for a Solution:

here my output:
sensor.fritzbox_connection_uptime => 2021-07-24T00:34:26+00:00

But I want to show the time: 1 Week, 2 Days, 3 Hours, 2 Second…

Thanks all

28

@basti4k
What have u tried and wich are the results? I gues you studied this tread?

29

i try this:

net_uptime:
      value_template: "{{ as_timestamp(strptime( states('sensor.fritzbox_connection_uptime'), '%Y-%m-%d %H:%M:%S')) | timestamp_custom('%Y-%m-%d %H:%M:%S') }}"
      unit_of_measurement: "Tage"
      friendly_name: "Verbunden"
      icon_template: mdi:calendar

For a other Day-Format. But now i search a “Counter”

30

here my solution:

net_uptime_pretty:
      friendly_name: Verbunden
      value_template: >
        {%- set up_time = as_timestamp(now())-as_timestamp(states('sensor.fritzbox_connection_uptime')) %}

        {% if states('sensor.last_boot') == '0.0' %}
          Soeben neu gestartet...
        {% else %}

        {%- macro phrase(name, divisor, mod=None) %}
          {%- set value = ((up_time // divisor) % (mod if mod else divisor)) | int %}
          {{- '{} {}'.format(value, name) if value | int > 0 else '' }}
        {%- endmacro %}

        {%- set values = [
          phrase('W.', 60*60*24*7),
          phrase('T.', 60*60*24, 7),
          phrase('Std.', 60*60, 24),
          phrase('Min.', 60),
          phrase('Sek.', 1, 60)
        ] | select('!=','') | list %}

        {{ values[:-1] | join(', ') ~ ' ' ~ values[-1] if values | length > 1 else values | first }}
        {% endif %}
1 Like
31

i tested the code that you posted, the list says when i use for example %A for the weekday he takes my selected language in HA, but he always make the weekday english, my language is german.

32

Please read the full thread. It has a solution to your problem.

33

okay, but i had problems to undestand how to add this to my code, perhaps you can give me a hint?

{{as_timestamp(strptime(state_attr('calendar.famillien_termine', 'start_time'), '%Y-%m-%d %H:%M:%S')) | timestamp_custom("%A %d.%b %-H:%M")}}
34

Sir, it’s literally posted above. Please read the thread. That requires you to read my post, then read the responses IN THIS THREAD.

Here’s a hint, this post has the code: