No announcements

### Time comparison problem with empty dates

What calculations do you use to compute these measures? The built-in time intelligence functions in DAX don't depend on whether or not there are records in the fact table, ...
| 1 Replies | 550 Views | Created by John Soloman - Monday, February 1, 2016 10:16 PM | Last reply by Michiel Rozema - NL - Tuesday, February 2, 2016 8:09 PM

### time and dates comparison

the time portion:         GROUP BY DATEADD(day, DATEDIFF(day, '19000101', OrderDate), '19000101') I still ...
| 13 Replies | 2475 Views | Created by Quantum Information - Tuesday, February 28, 2012 11:51 AM | Last reply by Gert-Jan Strik - Wednesday, February 29, 2012 1:49 PM

### Problem with Date Comparison

=' operation on System.DateTime and System.Double If I remove the 'DateValue' then it runs with no error, but also the comparison is not ...
| 7 Replies | 3124 Views | Created by Somebeach - Thursday, March 19, 2009 12:48 AM | Last reply by Reed Kimble - Thursday, March 19, 2009 8:21 PM

### DAX empty dates

Hi, Recently I had some trouble comparing empty dates, wich in sql server are 1/1/1753 . Seems like if I do a YEAR([mydate])=1753... ...
| 1 Replies | 2173 Views | Created by the_txeriff - Thursday, February 21, 2013 11:14 AM | Last reply by Laurent Couartou - Thursday, February 21, 2013 12:48 PM

### Problem with Dates

Hi I am using BIDS 2008R2 and I am trying to hard code a Report to restrict the dates returned in my output. My problem is this. I have a Field ...
| 3 Replies | 406 Views | Created by wha59 - Monday, August 17, 2015 3:02 PM | Last reply by wha59 - Monday, August 17, 2015 5:58 PM

### Time Comparison

. That's not what my watch says.") Goto start EndIf The problem with this code is that any time a user ...
| 1 Replies | 4107 Views | Created by EvilMishMish - Friday, June 18, 2010 6:41 PM | Last reply by litdev - Friday, June 18, 2010 7:00 PM

### > comparison not working for dates

I agree.  I advise people who are not working near the speed of light (or with time dilation problems) to use a datetime column.  ...
| 12 Replies | 811 Views | Created by Gina1111 - Friday, April 12, 2013 2:47 PM | Last reply by dbasnett - Monday, April 15, 2013 6:52 PM

### Time comparison

Hi Can somebody teach me that given 2 time for example: lblstarttime.text = now and lblendtime = now, how do i compare them in term of days, hour, minute and ...
| 6 Replies | 4523 Views | Created by kangalert - Monday, March 6, 2006 9:30 AM | Last reply by Neha Goyal - Wednesday, August 29, 2007 10:20 AM

### problem with dates

Hi again people i have this problem with the subtraction of dates used in my program. What i am trying to do is find the difference between two ...
| 11 Replies | 4175 Views | Created by Radoslav - Wednesday, January 31, 2007 12:50 AM | Last reply by Radoslav - Wednesday, January 31, 2007 11:04 PM

### Access 2003 working with empty dates

problem because they can only have null, or 0 - which yields a date in 1899 and would not be appropriate. So, we are asking what solutions folks know of ...
| 5 Replies | 720 Views | Created by ABDSP Paleo - Thursday, April 11, 2013 6:32 PM | Last reply by Ken Sheridan - Friday, April 12, 2013 5:03 PM

### Time Comparison

if your issue related to create LOGON trigger is general or to some work with dates Let's please go to the start 1
| 3 Replies | 319 Views | Created by grajee - Wednesday, January 10, 2018 4:53 AM | Last reply by grajee - Wednesday, January 10, 2018 6:10 AM

### Problem with comparison between schemas

and doesn't mantain the option that i wish. I tried with the option skip all to later go to individual objects to apply the desired action but don't work. Other ...
| 1 Replies | 5057 Views | Created by eduar284 - Thursday, August 19, 2010 5:23 PM | Last reply by Vicky Song - Friday, August 20, 2010 1:54 AM

### Date time Comparison

read this to understand data and time comparison
| 2 Replies | 426 Views | Created by Rajasentient - Saturday, June 14, 2014 10:06 AM | Last reply by Muthukrishnan Ramasamy - Saturday, June 14, 2014 5:44 PM

### BinaryFormatter problem with Dates

serialize my dataset into a binary file on the disk and read it back, it seems to be working fine. However there is one problem that if the DateTime value is empty in one of the ...
| 3 Replies | 7457 Views | Created by Haider Naqvi - Monday, January 16, 2006 9:35 AM | Last reply by Haider Naqvi - Tuesday, February 28, 2006 12:33 PM

### Problem with displaying dates

Hi ! I am new to VB .NET. I bound a textbox with a datetime type column of my sql server 2000 database. when I run the application the text box shows the date but it also adds time ...
| 4 Replies | 3502 Views | Created by SHISHIR WAHI - Tuesday, January 31, 2006 2:12 PM | Last reply by David A Nelson - Tuesday, January 31, 2006 3:09 PM

### Strange problem with dates

HI baba if you dont mine please dont change your question... Right now all I see is a strange problem with the dates....  The ...
| 10 Replies | 3148 Views | Created by babardondon - Sunday, August 28, 2011 12:22 AM | Last reply by Kalman Toth - Friday, September 2, 2011 3:31 PM

### Problem with insert dates

to insert date/time values in SQL as you have spotted, any string format (a.m for example) will not be allowed to be inserted in SQL. the formatting is automatically done ...
| 1 Replies | 2932 Views | Created by Kaos - Tuesday, September 5, 2006 1:23 PM | Last reply by ahmedilyas - Tuesday, September 5, 2006 2:24 PM

### Multiple Dates Comparison based on Columns.....

(), GETDATE()-1,GETDATE()-3, GETDATE()-4 UNION ALL SELECT 2, GETDATE()-5, GETDATE()-8,GETDATE()-7, GETDATE()-4 ;WITH CTE AS ( SELECT r.ID,r.Dts ...
| 3 Replies | 2116 Views | Created by Sonic.Jessy - Tuesday, June 26, 2012 3:36 PM | Last reply by Deepak Munigela - Tuesday, June 26, 2012 3:51 PM