Hello All    I have two dates in following format    Date 1 - December 11, 2018 05:15:20PM  Date 2 - January 21, 2018 01:25:21AM      How can i calculate difference between these two date in HOURS ?   Thanks in Advance ... View more

Hello Everyone,   Please understand the query bit correctly.   I have one value 'X' and for that i have thousands of observations (Values basically lie withing 0 to 200) Now what i want to build is a programing to set diffrent limits to this 'X'.   Example - I want to see how many observations are above 100 (Value of X)   In same program I should be able to see this results if i apply filter to see all the observations above 75 or lets say all the observations above 50 and so on...   Now I wrote following program (I know somehow i need to get rid of this ELSE ...but quetions is how?).       IF ( 'X' > 100 ) RETURN 'For 100' ELSE ( IF ( 'X' > 75 ) RETURN 'For 75' ELSE ( IF ( 'X' > 50 ) RETURN 'For 50' ELSE 'other' ) )W hat results it is showing is...For the limit of 100 it is showing right results ..but when i tried to see results for 50 or 75..it is showing me all the observations above 50 or 75 but below 100.   What i  want to see is all the observation above 75 and 50.   Could you please help for this on bit urgent basis. I will really appriciate.   Best Regards, Saurabh  ... View more

Hello    I have a simple query. I am trying to get output from selected variable if i apply diffrent limits then it should give me output of selected range   What i am facing is if i select show me values that are out side of 100..it is shouwing correct result  but if i select show me number of article outside of value 75..what it is showing is under 100 and above 75..   I want to see all the values above 75....   Following you will see the program that i wrote    IF ( 'RFPSCW'n > 100 ) RETURN 'For 100' ELSE ( IF ( 'RFPSCW'n > 75 ) RETURN 'For 75' ELSE ( IF ( 'RFPSCW'n > 50 ) RETURN 'For 50' ELSE 'other' ) ) please help to solve this    Thanks in advance  ... View more