Suggest an Idea

[simonaubert]

Hello all,

Datediff is a very, very common function in every BI Tools I know, from SQL (https://docs.microsoft.com/fr-fr/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15 ) to competitors products.

The concept is simple :

DATEDIFF ( datepart , startdate , enddate )  

where datepart can be month, week, year and so on. It's very useful, especially with month or years that can have a variagle length(28-31 and 365-366 days). 

Best regards,

Simon

[marcel_olmo]

Great idea @simonaubert . It will be very helpful.

[Patric_Nordstrom]

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Fyi, difference in days can calculated with subtraction and Interval can format to hours, min, secs 

Thanks,

Patric

[simonaubert]

@Patric_NordstromHello. Yep, I already use substraction for days or hours... I can divide by 7 for weeks but my difficulty is more with months or years that have variable length.

Moreover, this function is a standard in the industry.

Best regards,

Simon

[Olivier_W]

good idea

[Hanspeter]

Wäre sehr hilfreich. Gute Idee.

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.