No announcements
Found 1008264 threads
-
0 Votes
input Null datetime field
On the iwndow form I have multiple fields that were binded at run time to the SQL server table fields.Answered | 1 Replies | 7505 Views | Created by Thuy Tran - Tuesday, September 22, 2009 1:56 PM | Last reply by Shrikant Maske - Wednesday, September 23, 2009 1:38 PM -
1 Votes
Set DateTime field to null
Does it have to be null?Answered | 6 Replies | 16157 Views | Created by memarcie - Friday, January 18, 2008 1:36 PM | Last reply by memarcie - Friday, January 18, 2008 3:10 PM -
0 Votes
How to store null or empty value in datetime field?
If Ashish's code works then use that, i thought you cant have item["ResultDate"]=null; on datefiledAnswered | 6 Replies | 5865 Views | Created by Mark_Msft - Thursday, June 10, 2010 2:54 PM | Last reply by f00z - Thursday, June 10, 2010 8:50 PM -
1 Votes
NULL in DateTime
I always start to create a table with all fields as "NOT NULL".Answered | 6 Replies | 9236 Views | Created by MDMoura - Tuesday, July 17, 2012 9:12 AM | Last reply by MDMoura - Tuesday, July 17, 2012 9:50 AM -
0 Votes
DateTime field value cannot handle blank/null
It seems there's no way to set a date time field to null in TSWA. :( Could you help to file this issues to Visual Studio Connect?Answered | 2 Replies | 4469 Views | Created by Magnus Lovsten - Tuesday, December 2, 2008 12:46 PM | Last reply by Serkan Inci - Thursday, December 4, 2008 8:13 PM -
0 Votes
Convert NULL to datetime
Hi cool mind, in fact "Time" data field is a nvarchar(255) but I need to update this field with a datetime value in this format: 01/04/2010 ...Answered | 7 Replies | 23261 Views | Created by skurava - Tuesday, January 4, 2011 3:57 PM | Last reply by skurava - Tuesday, January 4, 2011 5:49 PM -
2 Votes
valid datetime value as input to executing stored procedure with DateTime input argument?
. What is wrong with what I have here since I'm getting the following error, Msg 8114, Level 16, State 1, Procedure Sems_PSEActivity_Modify_Rev1, ...Answered | 6 Replies | 4147 Views | Created by hazz - Tuesday, October 4, 2011 9:07 PM | Last reply by hazz - Tuesday, October 4, 2011 11:09 PM -
1 Votes
DateTime?
Nullable < DateTime > nullDateTime; or DateTime?Answered | 7 Replies | 11237 Views | Created by MDMoura - Monday, July 16, 2012 8:15 PM | Last reply by leveena_lap - Sunday, May 18, 2014 11:18 AM -
1 Votes
Sum a DATETIME field
It's a lot easier if you work with TIME fields...Answered | 15 Replies | 16855 Views | Created by Sam233 - Thursday, July 31, 2014 9:28 AM | Last reply by Muhammad Anees - Tuesday, January 14, 2020 10:48 AM -
0 Votes
DateTime field validation in Sharepoint
This ...Answered | 14 Replies | 11745 Views | Created by Betta123 - Wednesday, July 31, 2013 1:17 PM | Last reply by - Tuesday, August 6, 2013 5:57 AM -
0 Votes
update null value in access datetime
Assign null directly instead of DateTime.MinValue.Answered | 2 Replies | 4874 Views | Created by akki_adhikari - Friday, April 1, 2011 6:29 AM | Last reply by Adavesh - Friday, April 1, 2011 9:48 AM -
0 Votes
Null Field
FWIW, Uninitialized DateTime fields come up as DateTime.MinValue, which you can check against, and uninitialized int fields are set to 0.Answered | 1 Replies | 3936 Views | Created by MDMoura - Tuesday, September 15, 2009 5:20 PM | Last reply by Noam Ben-Ami - MSFT1 - Tuesday, September 15, 2009 5:35 PM -
2 Votes
DateTime null in a TextBlock
If it was a number you could use a three-section StringFormat, first section for positive, next for negative, last one for zero/null values: {Binding MyDoubleProp, ...Answered | 4 Replies | 12298 Views | Created by skuanet - Friday, January 21, 2011 10:33 PM | Last reply by Min Zhu - Wednesday, January 26, 2011 1:30 AM -
0 Votes
Writing a NULL datetime to a log
DECLARE @Note VARCHAR(500) DECLARE @PrevProcDateME DATETIME select ISNULL(@PrevProcDateME, '') Saeid Hasani, sqldevelop.wordpress.com ...Answered | 3 Replies | 1856 Views | Created by TheBrenda - Thursday, September 26, 2013 10:48 PM | Last reply by Jackson_1990 - Friday, September 27, 2013 2:03 AM -
0 Votes
How to check if object value is Null and if null assign NULL to type datetime
If you want to convert an object to a DateTime then Convert.ToDateTime will already handle null.Answered | 5 Replies | 10703 Views | Created by NewBInCoding - Wednesday, February 28, 2018 3:09 PM | Last reply by User3DX - Wednesday, February 28, 2018 11:47 PM -
5 Votes
how to update datetime field with empty datetime
So long as the field actually accepts null values; the dataset designer should have generated a Set<ColumnName>Null and ...Answered | 28 Replies | 4548 Views | Created by Mind-Reader - Monday, August 8, 2011 2:45 PM | Last reply by Reed Kimble - Thursday, August 11, 2011 3:58 PM -
0 Votes
Cost of comparing a datetime to NULL
50% of the time to return all records.Answered | 5 Replies | 9631 Views | Created by cgtyoder - Tuesday, February 1, 2011 9:12 PM | Last reply by TiborK - Wednesday, February 2, 2011 6:35 PM -
1 Votes
datetime null
You need to cast the date according to “load_date field” datatype(Date or datetime) shown ...Answered | 2 Replies | 2645 Views | Created by sql.anandan - Wednesday, November 30, 2011 5:27 AM | Last reply by SSISJoost - Wednesday, November 30, 2011 6:49 AM -
0 Votes
How to pass Null DateTime Value in Crystal 11
I think this one would help: http://jedsflipworld.xp3.biz/programming/how-to-pass-null-datetime-to-crystal-reports/Answered | 5 Replies | 17059 Views | Created by aravindanm - Tuesday, September 30, 2008 2:25 AM | Last reply by Nero Ethan - Friday, June 25, 2010 5:13 AM -
0 Votes
Update a DateTime with NULL from Textbox C# (LinqtoSql)
Im guessing the problem is that DateTime is a value type which means it cant be null by default.Answered | 2 Replies | 5066 Views | Created by Surfsista - Friday, February 13, 2009 5:19 PM | Last reply by Almagezt - Tuesday, February 17, 2009 11:08 AM - Items 1 to 20 of 1008264 Next ›
No announcements