Dates do not substract

davemontoya — Mon, 20 Dec 2021 21:38:40 GMT

Hi community, I have this line to subtract dates, but the result cell shows empty. No error shows when I run the script. What am I doing wrong? I also have other conditions "=" equal to something and does not work.

Table result:

azTienePending	azFinishResolved	azInicioAlerStart	StatusHistory.Pending.Time	azTTRMA
1	12/11/2019 18:04:36	1/11/2019 0:00:02	1/11/2019 2:07:23	-

,if([azTienePending]=1

, [azFinishResolved]-[azInicioAlerStart]

, [StatusHistory.Pending.Time]-[azInicioAlerStart])

as [azTTRMA]

//Attached qvd, qvf and excel. The script is in the loadeditor "seccion 7"

//https://drive.google.com/drive/folders/1wkqCzePm-itLFrU-6-Dx0OeL-UrhcMHy?usp=sharing

Re: Dates do not substract

jonathandienst — Mon, 13 Jan 2020 07:22:36 GMT

The dates are probably not being recognised by QS, so they are loaded as strings. Give QS a little help in the load script using:

LOAD ...
Date#(azFinishResolved, 'dd/MM/yyyy hh:mm:ss') as azFinishResolved,
Date#(azInicioAlerStart, 'dd/MM/yyyy hh:mm:ss') as azInicioAlerStart,
...

Now you should be able to perform date arithmetic on these fields.

topic Re: Dates do not substract in App Development

Dates do not substract

Re: Dates do not substract