Dates do not substract

[davemontoya]

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

[jonathandienst]

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.