Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

New function : Datediff to have the difference between two dates in month, week, year...

simonaubert
Partner - Specialist II
Partner - Specialist II

New function : Datediff to have the difference between two dates in month, week, year...

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

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
Tags (2)
7 Comments
marcel_olmo
Partner Ambassador
Partner Ambassador

Great idea @simonaubert . It will be very helpful.

Patric_Nordstrom
Employee
Employee

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

Status changed to: Open - Collecting Feedback
simonaubert
Partner - Specialist II
Partner - Specialist II

@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
Partner - Contributor III
Partner - Contributor III

good idea

Hanspeter
Contributor II
Contributor II

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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived