No announcements
Found 3915146 threads
-
0 Voteshow to get the uploaded document's last modified date?
How can we sort a library based on this actual file date?Answered | 5 Replies | 17674 Views | Created by Amira Aboulrous - Thursday, September 24, 2009 8:02 AM | Last reply by GrantFranks - Monday, June 28, 2010 1:03 PM
-
0 Votes
how to set null value to datetimepicker and textbox fields to save data into EF
Nullable value types (C# reference) DateTime?Answered | 2 Replies | 538 Views | Created by zleug - Monday, August 17, 2020 7:02 PM | Last reply by Timon Yang - Tuesday, August 18, 2020 8:14 AM -
0 Votes
How to convert a datetime field to a date field in SQL
refer this on how to do it http://www.sql-server-helper.com/tips/date-formats.aspx Hope it Helps!!Answered | 3 Replies | 1224 Views | Created by HadarK26288 - Sunday, May 17, 2015 1:14 PM | Last reply by Stan210 - Thursday, May 21, 2015 12:20 PM -
0 Votes
Retrive data from datetime field for given date.
As Stefan mentionned, you should use ISO format to avoid troubles.Answered | 4 Replies | 6684 Views | Created by Sanyon_d - Tuesday, May 3, 2011 8:47 AM | Last reply by StefDBA - Thursday, May 5, 2011 4:50 PM -
1 Votes
how add field -LAST DATE ROW UPDATE
Better to build a proper security model that restricts access to make adhoc changes to the database, and enforce the last update datetime logic with the application or a stored ...Answered | 6 Replies | 4473 Views | Created by gpspocket - Tuesday, July 7, 2009 10:20 AM | Last reply by SQLGuyChuck - Wednesday, July 8, 2009 12:44 AM -
3 Votes
Access 2013 Web App - How to add Last Modified Date and Last Modified User?
Using a textbox bound to a field in the table (I call it "TemporaryModifiedBy"), I used an On Current event on the datasheet view that runs a Data Macro ...Answered | 8 Replies | 5865 Views | Created by amanda.lam - Wednesday, March 4, 2015 10:50 PM | Last reply by GStyle73 - Wednesday, January 11, 2017 1:49 PM -
1 Votes
Set DateTime field to null
Hopefully this helps: 1)I didn't know how to query using the null, so I set the null date to 12/25/2020.Answered | 6 Replies | 16065 Views | Created by memarcie - Friday, January 18, 2008 1:36 PM | Last reply by memarcie - Friday, January 18, 2008 3:10 PM -
0 Votes
Convert Datetime field to display date
Although if your date time field is datetime type, then you don't need to do any conversion, you need to use ISO date format for dates to compare ...Answered | 9 Replies | 13824 Views | Created by tammali - Wednesday, August 9, 2006 6:09 AM | Last reply by Kalman Toth - Thursday, September 8, 2011 4:30 AM -
2 Votes
How can I get last modified date\time of file?
Also note that if you're using FileInfo then the information is cached so if you modify the file you'll need to call Refresh() to get it to refresh the data ...Answered | 5 Replies | 20892 Views | Created by [Archon] - Saturday, February 23, 2013 9:48 AM | Last reply by [Archon] - Sunday, February 24, 2013 8:41 AM -
3 Votes
Get DATE from DATETIME field
if you are using SQL Server 2005, only date or only time data types are not there. even if you extract the date some how and store it in the ...Answered | 7 Replies | 45041 Views | Created by Sam233 - Friday, July 29, 2011 9:24 AM | Last reply by Surendra Nath GM - Friday, July 29, 2011 9:49 AM -
0 Votes
Converting all datetime fields to datetime2 and date
One thing that you can do to datetime but not to the new date-related types are things like dateval + 2, you would have to use DATEADD() instead.Answered | 7 Replies | 3986 Views | Created by bagman3rd - Wednesday, January 6, 2010 4:23 PM | Last reply by Naomi N - Wednesday, January 6, 2010 6:27 PM -
2 Votes
loop through files based on last modified date
Hi, you can do one thing, load the file names and last modified datetime into some table.Answered | 3 Replies | 6537 Views | Created by rooyi - Friday, March 30, 2012 2:23 AM | Last reply by Raunak J - Friday, March 30, 2012 5:38 AM -
1 Votes
Setting a list Date field to it's date + 7 days using C#
I will modify that to set solution for your problem.Answered | 2 Replies | 4615 Views | Created by o365spo - Wednesday, August 8, 2012 12:12 AM | Last reply by Sharepoint Sutras - Friday, August 10, 2012 2:20 AM -
3 Votes
Query DateTime field by date range
Hi Scott, You can use CONVERT.Answered | 4 Replies | 641 Views | Created by scott_m - Wednesday, December 2, 2015 7:15 PM | Last reply by Aishwarya Tripathi - Wednesday, December 2, 2015 7:47 PM -
2 Votes
How Can i save date without time in datetime field
As Sean says, you can't store just the date in a DATETIME field.Answered | 5 Replies | 15854 Views | Created by Yasser Salah2 - Thursday, February 28, 2013 9:29 PM | Last reply by Yasser Salah2 - Saturday, March 2, 2013 7:43 PM -
1 Votes
DateTime fields only showing date, not time
Question now is how to set the "Date and Time Format" programmatically to "Date & Time".Answered | 6 Replies | 12547 Views | Created by five13 - Monday, August 31, 2009 2:48 PM | Last reply by five13 - Tuesday, September 1, 2009 6:50 AM -
0 Votes
How To Formate Date Time To Date Dynamically
The field type will be datetime or it will be a string type (like varchar).Answered | 4 Replies | 2457 Views | Created by thanneru.vasu - Friday, November 9, 2012 3:20 PM | Last reply by Tim Pacl - Friday, November 9, 2012 10:37 PM -
0 Votes
DateTime
You can certainly declare your DateTime column in the database to be nullable, and you can also declare your DateTime property in your EntityType to be nullable.Answered | 1 Replies | 3474 Views | Created by MDMoura - Thursday, September 3, 2009 4:19 PM | Last reply by Noam Ben-Ami - MSFT1 - Thursday, September 3, 2009 8:51 PM -
0 Votes
converting varchar to datetime where date field is missing
I am already using this query but my question is for query execution time of large number of data.Answered | 10 Replies | 1762 Views | Created by Srimanta Manna - Tuesday, December 24, 2013 10:49 AM | Last reply by Elvis Long - Tuesday, December 31, 2013 8:40 AM -
1 Votes
How to get The Modified date of image ??
However, using the datetaken and the last file name you can probably see if it is a modification date or an original date.Answered | 16 Replies | 5157 Views | Created by JophyJob - Wednesday, January 16, 2013 6:21 AM | Last reply by Cor Ligthert - Thursday, January 24, 2013 4:17 PM - Items 1 to 20 of 3915146 Next ›
No announcements
