Jana.safferova: založena nová stránka s textem „Tasha sends all dynamic columns as text when importing data into KPI. One dynamic column (in the example, the [JobDynamicField19] column) stores the date and time in the format d.M.yyyy H:mm:ss. You need to get the correct date from the dynamic field.“

2022-08-18T09:37:23Z

založena nová stránka s textem „Tasha sends all dynamic columns as text when importing data into KPI. One dynamic column (in the example, the [JobDynamicField19] column) stores the date and time in the format d.M.yyyy H:mm:ss. You need to get the correct date from the dynamic field.“

Nová stránka

<languages />
Tasha sends all dynamic columns as text when importing data into KPI. One dynamic column (in the example, the [JobDynamicField19] column) stores the date and time in the format d.M.yyyy H:mm:ss. You need to get the correct date from the dynamic field.

'''Solution'''

Add CalculatedField with the following text:

<code> 1 MakeDateTime(ToInt(Replace(Replace(Remove(Reverse(Remove(Reverse([JobDynamicField19]), 0, 8)), 0, 6), ' ', ''), '.', '')), ToInt(Replace(Replace(Remove(Remove([JobDynamicField19], 0, 2), 4), '.', ''), ' ', '')), ToInt(Replace(Remove([JobDynamicField19], 2), '.', ''))) </code><br />

TAS:Pokročilé/Pluginy/KPI/Převod textu na datum/en - Historie editací