You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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*
UPDATE: From one of the online post, I was able to find the answer.
Hi @Leona Vo ,
You may also try the following SQL query:
AS 'Date Diff'
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.
Thanks for your post. I also had a similar issue previously but right now i have got the ticket age from your query but next is that i also need that out of the total days say 100 there will be Saturday and Sunday as well , how to reflect correct number of days in Integer excluding Weekends. Any help here will be much appreciated!!