No announcements
Found 1512048 threads
-
6 VotesUpdate DATE field with Random Dates
This table-valued function can then be used in with an INNER join to a view over the dates you want to update that uses ROW_NUMBER().Answered | 5 Replies | 3059 Views | Created by cdun2 - Tuesday, April 17, 2012 1:55 PM | Last reply by cdun2 - Tuesday, April 17, 2012 10:27 PM
-
0 Votes
Updateing Date fields
update MyTable set DateField=dateadd(minute,[Hour]*60+[Minutes],DateField) This, of course, assumes that the DateField has no time in it at all to start out with.Answered | 1 Replies | 4890 Views | Created by geneway - Tuesday, September 29, 2009 5:35 PM | Last reply by Brad_Schulz - Tuesday, September 29, 2009 5:41 PM -
1 Votes
how add field -LAST DATE ROW UPDATE
If that is the case, using an update trigger to update the LAST DATE ROW UPDATE field will do the trick.Answered | 6 Replies | 4400 Views | Created by gpspocket - Tuesday, July 7, 2009 10:20 AM | Last reply by SQLGuyChuck - Wednesday, July 8, 2009 12:44 AM -
1 Votes
Can't Delete Date Field in data bound form
If you want to update the field in the database as a Data base Null type, than you have to update the field as a DBNull.Value ...Answered | 5 Replies | 3085 Views | Created by GFuller - Thursday, October 15, 2009 6:44 PM | Last reply by Dig-Boy - Friday, October 16, 2009 4:55 PM -
0 Votes
Using SPD to update date field when field is empty
I use it to get Closed Out Date field’s value.Answered | 1 Replies | 3034 Views | Created by Kim AMD - Monday, September 3, 2012 4:51 PM | Last reply by Emir Liu - Tuesday, September 4, 2012 6:33 AM -
0 Votes
SharePoint 2010 Date based on field update
If it hasn't then we set it to the current date/time.Answered | 2 Replies | 1505 Views | Created by rmcfarron - Thursday, April 24, 2014 5:47 PM | Last reply by Bil Simser [MVP] - Friday, April 25, 2014 2:36 PM -
0 Votes
TFPT worktitem /update fails on create date and closed date fields
I am using tfpt workitem /update to change field values.Answered | 1 Replies | 4693 Views | Created by stevepink - Tuesday, February 17, 2009 8:16 PM | Last reply by Bill.Wang - Monday, February 23, 2009 6:24 AM -
0 Votes
Need help with SSIS package to update or delete records based on fields in a different table and update a commitdate field with the date
If the category field ='C' the existing record in the current table needs to be updated.Answered | 7 Replies | 6479 Views | Created by Ferg1349 - Wednesday, July 14, 2010 4:08 AM | Last reply by Ferg1349 - Wednesday, August 11, 2010 8:44 PM -
1 Votes
creating a calculated field based on another date field
I will mark this as answered since you did answer my question as I posted it :) But... since the calculated field dosn't update this is really not a solution ...Answered | 9 Replies | 6463 Views | Created by Jaylou - Friday, February 6, 2009 2:15 PM | Last reply by Huzefa Mala - Wednesday, February 11, 2009 6:07 PM -
0 Votes
Calculated Date Field with Truncating
It introduces redundancy and leaves the table wide open to update anomalies.Answered | 11 Replies | 510 Views | Created by Bill Fry - Tuesday, November 24, 2015 10:44 PM | Last reply by Imb-hb - Tuesday, December 1, 2015 4:36 PM -
0 Votes
SQL Update the date portion of a datetime field
Hello, I need a SQL statement to update the date portion of a datetime field.Answered | 1 Replies | 1016 Views | Created by jpkolb - Tuesday, August 12, 2014 3:50 PM | Last reply by scott_morris-ga - Tuesday, August 12, 2014 4:56 PM -
1 Votes
Entering Date in to a table field?
Sorry, copy and paste error: Replace the keyword SELECT with UPDATE in the SQL String.Answered | 5 Replies | 539 Views | Created by TurnipOrange - Sunday, July 27, 2014 10:53 PM | Last reply by TurnipOrange - Monday, July 28, 2014 3:00 AM -
2 Votes
Allowing text in Date Field
Is there any reason you can't just leave the field blank -- i.e., Null -- and interpret that as "N/A"?Answered | 4 Replies | 285 Views | Created by JHarding08 - Thursday, May 17, 2018 5:17 PM | Last reply by .theDBguy - Thursday, May 24, 2018 8:09 PM -
0 Votes
Changing field based on another field and current date
This will help you to check daily all expiration dates in the table and then update the records who are expired.Answered | 2 Replies | 2392 Views | Created by LKimberlyB - Monday, January 28, 2013 4:15 PM | Last reply by SathyanarrayananS - Monday, January 28, 2013 4:59 PM -
0 Votes
Date field to make Readonly
Hi, Select the "Default value:" for Date field as "Today's Date" and use "List Manager" feature available in codeplex to ...Answered | 3 Replies | 5369 Views | Created by upulchandu - Wednesday, May 12, 2010 7:27 AM | Last reply by upulchandu - Wednesday, June 23, 2010 1:09 PM -
0 Votes
appending date fields in VFP9
I decided to try different delimiter characters in the incoming dates to see what would happen.Answered | 5 Replies | 5245 Views | Created by GeofS - Thursday, August 21, 2008 7:45 PM | Last reply by GeofS - Friday, August 22, 2008 2:06 PM -
0 Votes
group by date field bug in list view if date field is lookup column
Hi, Please install the latest cumulative update for SharePoint 2013.Answered | 1 Replies | 679 Views | Created by vlnSharePoint - Wednesday, July 29, 2015 1:44 PM | Last reply by Dennis Guo - Thursday, July 30, 2015 7:04 AM -
2 Votes
Timezone problem for date fields
But we are storing the values in UTC only, the problem is only for date fields and not for DateTime fields.Answered | 6 Replies | 1401 Views | Created by Vetrivelmurugan - Wednesday, June 26, 2013 8:33 AM | Last reply by Joel Engineer - Wednesday, June 26, 2013 10:59 AM -
0 Votes
Custom Static Date Field
Since its a text field it came with a caveat, sorting was not working like date its text sort, search refiners needed some special attention etc.Answered | 7 Replies | 773 Views | Created by Wendy Attenberger - Thursday, July 28, 2016 4:42 PM | Last reply by Rajesh.Sitaraman - Saturday, August 6, 2016 2:54 AM -
0 Votes
Clear a date field in db
Justin, The field of DateCompleted is not a required field and when the entry is created it is a null value and only gets a datetime when the ...Answered | 3 Replies | 993 Views | Created by Stu Ryan - Saturday, August 24, 2013 1:04 AM | Last reply by Stu Ryan - Saturday, August 24, 2013 6:59 PM - Items 1 to 20 of 1512048 Next ›
No announcements
