Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-09-25 07:55 AM

difference between date type values

hello,

i have date-time data coming in from sql server in the form of integar

ex:  one column 'abc' contains values such as :  1002171551 (date value in: yymmddhhmm)

2nd column 'def' contains values such as : 100217 or 1002170000 (date value in: yymmdd)

now i need to calculate difference between these two columns and i want sql server to treat these as date columns and not integar ones.

right now when i do the difference i get result purely as in subtraction of 2 integar values. but i want the result to be calculated as a difference between dates.s

any suggestions? 

1,404 Views
0 Likes
10 Replies
Not applicable
‎2012-09-27 04:34 AM
Author

Hi,

Based on your example, I loaded it inline, used the makedate function to get the proper date format. Now you can compute for the date difference. See the attached file for your reference.

Regards,

Janzen

Date difference.qvw
122 Views