- ioBroker Community Home
- Deutsch
- Skripten / Logik
- Blockly
- [Eingestellt]: Differenz zweier Datums-DP
NEWS
[Eingestellt]: Differenz zweier Datums-DP
-
@HeinrichB sagte in [Eingestellt]: Differenz zweier Datums-DP:
Ich hatte es mir als eine einfache Sache vorgestellt
Was ist denn jetzt nicht einfach??
Nur weil ich, der nicht skripten kann, es nicht weiß?
@Homoran Nein, es ist zuviel Aufwand für euch alle.
-
@Homoran Nein, es ist zuviel Aufwand für euch alle.
@HeinrichB sagte:
es ist zuviel Aufwand für euch alle.
Ist es nicht. Ein Datum im Format dd.mm.yyyy muss umgewandelt werden in ein Format yyyy-mm-dd, damit es konvertiert werden kann.

<xml xmlns="http://www.w3.org/1999/xhtml"> <variables> <variable type="" id="gL!a815B-lSOIZwGTf5~">datum</variable> <variable type="" id="xqWuWy*##]f:{aNWj|0k">Zeitdifferenz</variable> </variables> <block type="procedures_defreturn" id="%d.Lx10#X98K{nh@Q)O[" x="37" y="-63"> <mutation> <arg name="datum" varid="gL!a815B-lSOIZwGTf5~"></arg> </mutation> <field name="NAME">Datum2ms</field> <comment pinned="false" h="80" w="160">Beschreibe diese Funktion …</comment> <statement name="STACK"> <block type="variables_set" id="~lU1i?q89DoJ~.!0EHHo"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> <value name="VALUE"> <block type="lists_split" id="l=mI77^xeS.P4d.01q5E"> <mutation mode="SPLIT"></mutation> <field name="MODE">SPLIT</field> <value name="INPUT"> <block type="variables_get" id="tCRDDd:RR2gWxEU`iqzf"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="DELIM"> <shadow type="text" id="J+MV42tSJPSrcI%(MAg*"> <field name="TEXT">.</field> </shadow> </value> </block> </value> <next> <block type="variables_set" id="y3eG5o.L|g,4ef6*2X53"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> <value name="VALUE"> <block type="text_join" id="z8fwV+}GIQwpb^}-RI}g"> <mutation items="5"></mutation> <value name="ADD0"> <block type="lists_getIndex" id="WP[JReg?+~+LPQxG_@M2"> <mutation statement="false" at="true"></mutation> <field name="MODE">GET</field> <field name="WHERE">FROM_START</field> <value name="VALUE"> <block type="variables_get" id="%,-[6x8o4aRE|PZ,nR5E"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="AT"> <block type="math_number" id="(dI9@FOg_C|)E%F/AorD"> <field name="NUM">3</field> </block> </value> </block> </value> <value name="ADD1"> <block type="text" id="OY2Yua:$AY,t+]Lc)Z8I"> <field name="TEXT">-</field> </block> </value> <value name="ADD2"> <block type="lists_getIndex" id="5NSC@1{C#cYT/aUW3:+~"> <mutation statement="false" at="true"></mutation> <field name="MODE">GET</field> <field name="WHERE">FROM_START</field> <value name="VALUE"> <block type="variables_get" id="+tLaz)}KqVWarSb?(q%G"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="AT"> <block type="math_number" id="KK@|_2Nm|j=9@_)wI8hu"> <field name="NUM">2</field> </block> </value> </block> </value> <value name="ADD3"> <block type="text" id="ke/6GufbVzq;c43`TDL?"> <field name="TEXT">-</field> </block> </value> <value name="ADD4"> <block type="lists_getIndex" id="XNlpu$^GR/+Nq.??5wwg"> <mutation statement="false" at="true"></mutation> <field name="MODE">GET</field> <field name="WHERE">FROM_START</field> <value name="VALUE"> <block type="variables_get" id="fpE*2H2(A1g8yDUQKhT-"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="AT"> <block type="math_number" id="hA:?b!N9Y_:no1oVnzyS"> <field name="NUM">1</field> </block> </value> </block> </value> </block> </value> </block> </next> </block> </statement> <value name="RETURN"> <block type="convert_from_date" id="Oe(q.AD)hV0*J`ve*^CN"> <mutation format="false" language="false"></mutation> <field name="OPTION">object</field> <value name="VALUE"> <block type="variables_get" id="gHmH!qA*/]SkJuqD=@+p"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> </block> </value> </block> <block type="on_ext" id="iaBLIinyq,K=hAV*;k%f" x="38" y="213"> <mutation items="1"></mutation> <field name="CONDITION">ne</field> <field name="ACK_CONDITION"></field> <value name="OID0"> <shadow type="field_oid" id="j%v-elP`*f5]tkjlxrns"> <field name="oid">default</field> </shadow> </value> <statement name="STATEMENT"> <block type="variables_set" id="/:)C.{I!fB3z%X]%Au_i"> <field name="VAR" id="xqWuWy*##]f:{aNWj|0k" variabletype="">Zeitdifferenz</field> <value name="VALUE"> <block type="math_arithmetic" id="zP-LvQ]qfHYht=H]25NV" inline="false"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number" id="F;)q:+Z=_$vKj3$iTWR;"> <field name="NUM">1</field> </shadow> <block type="time_get" id="u`R9-cfB:qz*3R;Dq~ap"> <mutation format="false" language="false"></mutation> <field name="OPTION">object</field> </block> </value> <value name="B"> <shadow type="math_number" id="PAg*1M%tyNbF{(pbsWnk"> <field name="NUM">1</field> </shadow> <block type="procedures_callreturn" id="WzsL$_xM;SvdzA[4CUmT"> <mutation name="Datum2ms"> <arg name="datum"></arg> </mutation> <value name="ARG0"> <block type="get_value" id=")[1PLS3Xo%yTAOjAh[`v"> <field name="ATTR">val</field> <field name="OID">ID auswählen</field> </block> </value> </block> </value> </block> </value> <next> <block type="update" id=")^y++_%S/^fIU8tKL|Ka"> <mutation delay_input="false"></mutation> <field name="OID">Object ID</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_round" id="tP}@DK.iPY`z#|!la5rV"> <field name="OP">ROUNDDOWN</field> <value name="NUM"> <shadow type="math_number" id="XQ|R*FY}-kcXscPZ8p{["> <field name="NUM">3.1</field> </shadow> <block type="math_arithmetic" id="!GFLijUhd-E/uImbe)-D"> <field name="OP">DIVIDE</field> <value name="A"> <shadow type="math_number" id="}!W0Si}sMIz5.hpDj_t@"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="lp-`qW:xvX$AH`;H:6:m"> <field name="VAR" id="xqWuWy*##]f:{aNWj|0k" variabletype="">Zeitdifferenz</field> </block> </value> <value name="B"> <shadow type="math_number" id="k(b?|li^/=,~a5i4n{q_"> <field name="NUM">86400000</field> </shadow> </value> </block> </value> </block> </value> <next> <block type="update" id="9JinxiH`x_B}.Iai]|lf"> <mutation delay_input="false"></mutation> <field name="OID">Object ID</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="time_get" id="7ZI{o,-RCI9cjUQhktx~"> <mutation format="false" language="false"></mutation> <field name="OPTION">DD.MM.YYYY</field> </block> </value> </block> </next> </block> </next> </block> </statement> </block> </xml>Bitte verzichtet auf Chat-Nachrichten, denn die Handhabung ist grauenhaft !
Produktiv: RPi 2 mit S.USV, HM-MOD-RPI und SLC-USB-Stick mit root fs -
@HeinrichB sagte:
es ist zuviel Aufwand für euch alle.
Ist es nicht. Ein Datum im Format dd.mm.yyyy muss umgewandelt werden in ein Format yyyy-mm-dd, damit es konvertiert werden kann.

<xml xmlns="http://www.w3.org/1999/xhtml"> <variables> <variable type="" id="gL!a815B-lSOIZwGTf5~">datum</variable> <variable type="" id="xqWuWy*##]f:{aNWj|0k">Zeitdifferenz</variable> </variables> <block type="procedures_defreturn" id="%d.Lx10#X98K{nh@Q)O[" x="37" y="-63"> <mutation> <arg name="datum" varid="gL!a815B-lSOIZwGTf5~"></arg> </mutation> <field name="NAME">Datum2ms</field> <comment pinned="false" h="80" w="160">Beschreibe diese Funktion …</comment> <statement name="STACK"> <block type="variables_set" id="~lU1i?q89DoJ~.!0EHHo"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> <value name="VALUE"> <block type="lists_split" id="l=mI77^xeS.P4d.01q5E"> <mutation mode="SPLIT"></mutation> <field name="MODE">SPLIT</field> <value name="INPUT"> <block type="variables_get" id="tCRDDd:RR2gWxEU`iqzf"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="DELIM"> <shadow type="text" id="J+MV42tSJPSrcI%(MAg*"> <field name="TEXT">.</field> </shadow> </value> </block> </value> <next> <block type="variables_set" id="y3eG5o.L|g,4ef6*2X53"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> <value name="VALUE"> <block type="text_join" id="z8fwV+}GIQwpb^}-RI}g"> <mutation items="5"></mutation> <value name="ADD0"> <block type="lists_getIndex" id="WP[JReg?+~+LPQxG_@M2"> <mutation statement="false" at="true"></mutation> <field name="MODE">GET</field> <field name="WHERE">FROM_START</field> <value name="VALUE"> <block type="variables_get" id="%,-[6x8o4aRE|PZ,nR5E"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="AT"> <block type="math_number" id="(dI9@FOg_C|)E%F/AorD"> <field name="NUM">3</field> </block> </value> </block> </value> <value name="ADD1"> <block type="text" id="OY2Yua:$AY,t+]Lc)Z8I"> <field name="TEXT">-</field> </block> </value> <value name="ADD2"> <block type="lists_getIndex" id="5NSC@1{C#cYT/aUW3:+~"> <mutation statement="false" at="true"></mutation> <field name="MODE">GET</field> <field name="WHERE">FROM_START</field> <value name="VALUE"> <block type="variables_get" id="+tLaz)}KqVWarSb?(q%G"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="AT"> <block type="math_number" id="KK@|_2Nm|j=9@_)wI8hu"> <field name="NUM">2</field> </block> </value> </block> </value> <value name="ADD3"> <block type="text" id="ke/6GufbVzq;c43`TDL?"> <field name="TEXT">-</field> </block> </value> <value name="ADD4"> <block type="lists_getIndex" id="XNlpu$^GR/+Nq.??5wwg"> <mutation statement="false" at="true"></mutation> <field name="MODE">GET</field> <field name="WHERE">FROM_START</field> <value name="VALUE"> <block type="variables_get" id="fpE*2H2(A1g8yDUQKhT-"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="AT"> <block type="math_number" id="hA:?b!N9Y_:no1oVnzyS"> <field name="NUM">1</field> </block> </value> </block> </value> </block> </value> </block> </next> </block> </statement> <value name="RETURN"> <block type="convert_from_date" id="Oe(q.AD)hV0*J`ve*^CN"> <mutation format="false" language="false"></mutation> <field name="OPTION">object</field> <value name="VALUE"> <block type="variables_get" id="gHmH!qA*/]SkJuqD=@+p"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> </block> </value> </block> <block type="on_ext" id="iaBLIinyq,K=hAV*;k%f" x="38" y="213"> <mutation items="1"></mutation> <field name="CONDITION">ne</field> <field name="ACK_CONDITION"></field> <value name="OID0"> <shadow type="field_oid" id="j%v-elP`*f5]tkjlxrns"> <field name="oid">default</field> </shadow> </value> <statement name="STATEMENT"> <block type="variables_set" id="/:)C.{I!fB3z%X]%Au_i"> <field name="VAR" id="xqWuWy*##]f:{aNWj|0k" variabletype="">Zeitdifferenz</field> <value name="VALUE"> <block type="math_arithmetic" id="zP-LvQ]qfHYht=H]25NV" inline="false"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number" id="F;)q:+Z=_$vKj3$iTWR;"> <field name="NUM">1</field> </shadow> <block type="time_get" id="u`R9-cfB:qz*3R;Dq~ap"> <mutation format="false" language="false"></mutation> <field name="OPTION">object</field> </block> </value> <value name="B"> <shadow type="math_number" id="PAg*1M%tyNbF{(pbsWnk"> <field name="NUM">1</field> </shadow> <block type="procedures_callreturn" id="WzsL$_xM;SvdzA[4CUmT"> <mutation name="Datum2ms"> <arg name="datum"></arg> </mutation> <value name="ARG0"> <block type="get_value" id=")[1PLS3Xo%yTAOjAh[`v"> <field name="ATTR">val</field> <field name="OID">ID auswählen</field> </block> </value> </block> </value> </block> </value> <next> <block type="update" id=")^y++_%S/^fIU8tKL|Ka"> <mutation delay_input="false"></mutation> <field name="OID">Object ID</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_round" id="tP}@DK.iPY`z#|!la5rV"> <field name="OP">ROUNDDOWN</field> <value name="NUM"> <shadow type="math_number" id="XQ|R*FY}-kcXscPZ8p{["> <field name="NUM">3.1</field> </shadow> <block type="math_arithmetic" id="!GFLijUhd-E/uImbe)-D"> <field name="OP">DIVIDE</field> <value name="A"> <shadow type="math_number" id="}!W0Si}sMIz5.hpDj_t@"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="lp-`qW:xvX$AH`;H:6:m"> <field name="VAR" id="xqWuWy*##]f:{aNWj|0k" variabletype="">Zeitdifferenz</field> </block> </value> <value name="B"> <shadow type="math_number" id="k(b?|li^/=,~a5i4n{q_"> <field name="NUM">86400000</field> </shadow> </value> </block> </value> </block> </value> <next> <block type="update" id="9JinxiH`x_B}.Iai]|lf"> <mutation delay_input="false"></mutation> <field name="OID">Object ID</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="time_get" id="7ZI{o,-RCI9cjUQhktx~"> <mutation format="false" language="false"></mutation> <field name="OPTION">DD.MM.YYYY</field> </block> </value> </block> </next> </block> </next> </block> </statement> </block> </xml>@paul53 Danke; ich probiere mich mal dran :)
-
@HeinrichB sagte:
es ist zuviel Aufwand für euch alle.
Ist es nicht. Ein Datum im Format dd.mm.yyyy muss umgewandelt werden in ein Format yyyy-mm-dd, damit es konvertiert werden kann.

<xml xmlns="http://www.w3.org/1999/xhtml"> <variables> <variable type="" id="gL!a815B-lSOIZwGTf5~">datum</variable> <variable type="" id="xqWuWy*##]f:{aNWj|0k">Zeitdifferenz</variable> </variables> <block type="procedures_defreturn" id="%d.Lx10#X98K{nh@Q)O[" x="37" y="-63"> <mutation> <arg name="datum" varid="gL!a815B-lSOIZwGTf5~"></arg> </mutation> <field name="NAME">Datum2ms</field> <comment pinned="false" h="80" w="160">Beschreibe diese Funktion …</comment> <statement name="STACK"> <block type="variables_set" id="~lU1i?q89DoJ~.!0EHHo"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> <value name="VALUE"> <block type="lists_split" id="l=mI77^xeS.P4d.01q5E"> <mutation mode="SPLIT"></mutation> <field name="MODE">SPLIT</field> <value name="INPUT"> <block type="variables_get" id="tCRDDd:RR2gWxEU`iqzf"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="DELIM"> <shadow type="text" id="J+MV42tSJPSrcI%(MAg*"> <field name="TEXT">.</field> </shadow> </value> </block> </value> <next> <block type="variables_set" id="y3eG5o.L|g,4ef6*2X53"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> <value name="VALUE"> <block type="text_join" id="z8fwV+}GIQwpb^}-RI}g"> <mutation items="5"></mutation> <value name="ADD0"> <block type="lists_getIndex" id="WP[JReg?+~+LPQxG_@M2"> <mutation statement="false" at="true"></mutation> <field name="MODE">GET</field> <field name="WHERE">FROM_START</field> <value name="VALUE"> <block type="variables_get" id="%,-[6x8o4aRE|PZ,nR5E"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="AT"> <block type="math_number" id="(dI9@FOg_C|)E%F/AorD"> <field name="NUM">3</field> </block> </value> </block> </value> <value name="ADD1"> <block type="text" id="OY2Yua:$AY,t+]Lc)Z8I"> <field name="TEXT">-</field> </block> </value> <value name="ADD2"> <block type="lists_getIndex" id="5NSC@1{C#cYT/aUW3:+~"> <mutation statement="false" at="true"></mutation> <field name="MODE">GET</field> <field name="WHERE">FROM_START</field> <value name="VALUE"> <block type="variables_get" id="+tLaz)}KqVWarSb?(q%G"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="AT"> <block type="math_number" id="KK@|_2Nm|j=9@_)wI8hu"> <field name="NUM">2</field> </block> </value> </block> </value> <value name="ADD3"> <block type="text" id="ke/6GufbVzq;c43`TDL?"> <field name="TEXT">-</field> </block> </value> <value name="ADD4"> <block type="lists_getIndex" id="XNlpu$^GR/+Nq.??5wwg"> <mutation statement="false" at="true"></mutation> <field name="MODE">GET</field> <field name="WHERE">FROM_START</field> <value name="VALUE"> <block type="variables_get" id="fpE*2H2(A1g8yDUQKhT-"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> <value name="AT"> <block type="math_number" id="hA:?b!N9Y_:no1oVnzyS"> <field name="NUM">1</field> </block> </value> </block> </value> </block> </value> </block> </next> </block> </statement> <value name="RETURN"> <block type="convert_from_date" id="Oe(q.AD)hV0*J`ve*^CN"> <mutation format="false" language="false"></mutation> <field name="OPTION">object</field> <value name="VALUE"> <block type="variables_get" id="gHmH!qA*/]SkJuqD=@+p"> <field name="VAR" id="gL!a815B-lSOIZwGTf5~" variabletype="">datum</field> </block> </value> </block> </value> </block> <block type="on_ext" id="iaBLIinyq,K=hAV*;k%f" x="38" y="213"> <mutation items="1"></mutation> <field name="CONDITION">ne</field> <field name="ACK_CONDITION"></field> <value name="OID0"> <shadow type="field_oid" id="j%v-elP`*f5]tkjlxrns"> <field name="oid">default</field> </shadow> </value> <statement name="STATEMENT"> <block type="variables_set" id="/:)C.{I!fB3z%X]%Au_i"> <field name="VAR" id="xqWuWy*##]f:{aNWj|0k" variabletype="">Zeitdifferenz</field> <value name="VALUE"> <block type="math_arithmetic" id="zP-LvQ]qfHYht=H]25NV" inline="false"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number" id="F;)q:+Z=_$vKj3$iTWR;"> <field name="NUM">1</field> </shadow> <block type="time_get" id="u`R9-cfB:qz*3R;Dq~ap"> <mutation format="false" language="false"></mutation> <field name="OPTION">object</field> </block> </value> <value name="B"> <shadow type="math_number" id="PAg*1M%tyNbF{(pbsWnk"> <field name="NUM">1</field> </shadow> <block type="procedures_callreturn" id="WzsL$_xM;SvdzA[4CUmT"> <mutation name="Datum2ms"> <arg name="datum"></arg> </mutation> <value name="ARG0"> <block type="get_value" id=")[1PLS3Xo%yTAOjAh[`v"> <field name="ATTR">val</field> <field name="OID">ID auswählen</field> </block> </value> </block> </value> </block> </value> <next> <block type="update" id=")^y++_%S/^fIU8tKL|Ka"> <mutation delay_input="false"></mutation> <field name="OID">Object ID</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_round" id="tP}@DK.iPY`z#|!la5rV"> <field name="OP">ROUNDDOWN</field> <value name="NUM"> <shadow type="math_number" id="XQ|R*FY}-kcXscPZ8p{["> <field name="NUM">3.1</field> </shadow> <block type="math_arithmetic" id="!GFLijUhd-E/uImbe)-D"> <field name="OP">DIVIDE</field> <value name="A"> <shadow type="math_number" id="}!W0Si}sMIz5.hpDj_t@"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="lp-`qW:xvX$AH`;H:6:m"> <field name="VAR" id="xqWuWy*##]f:{aNWj|0k" variabletype="">Zeitdifferenz</field> </block> </value> <value name="B"> <shadow type="math_number" id="k(b?|li^/=,~a5i4n{q_"> <field name="NUM">86400000</field> </shadow> </value> </block> </value> </block> </value> <next> <block type="update" id="9JinxiH`x_B}.Iai]|lf"> <mutation delay_input="false"></mutation> <field name="OID">Object ID</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="time_get" id="7ZI{o,-RCI9cjUQhktx~"> <mutation format="false" language="false"></mutation> <field name="OPTION">DD.MM.YYYY</field> </block> </value> </block> </next> </block> </next> </block> </statement> </block> </xml>@paul53 said in [Eingestellt]: Differenz zweier Datums-DP:
Ein Datum im Format dd.mm.yyyy muss umgewandelt werden in ein Format yyyy-mm-dd
Das war der Knackpunkt. Vielen Dank dafür. ich habe Deine Skripts lesen können und damit mein Skript aufgebaut. Nicht so generisch wie das Deinige aber es tut es :)
Danke