Calculate days since created table transformer

Leona Vo

Hi,

In my Table Transformer, I would like to calculate the number of days since Created.

The following select statement produces what you see in the attached.

SELECT FORMATDATE(NOW()), FORMATDATE(T1.'Created') FROM T*

However, the below produces nothing. What am I missing?

SELECT FORMATDATE(NOW()) - FORMATDATE(T1.'Created') FROM T*

Thank you.

 

UPDATE: From one of the online post, I was able to find the answer.

(CAST(ROUND(ceiling(DATEDIFF(DAY,T1.'Created',NOW())))as int))

 

Katerina Kovriga {Stiltsoft}

Hi @Leona Vo ,

You may also try the following SQL query:

SELECT *,
DATEDIFF(day,T1.'Date',"today")
AS 'Date Diff'
FROM T*

The date format for this example in the Table Transformer macro settings (Settings tab -> Date format) should be set as "m/d/y".

Hope this also helps.