No announcements
Found 1452076 threads
-
1 Votesformat dates from dd/mm/yyyy to mm/dd/yyyy format
Hi, If you're programming with VBA, you can write some thing like Dim wks As Excel.Worksheet Set wks = Worksheets(1) Dim ...Answered | 3 Replies | 4813 Views | Created by Cire1507 - Monday, April 11, 2011 11:06 AM | Last reply by Carlos Mallen - Monday, April 11, 2011 8:24 PM
-
1 Votes
Check date format is dd/mm/yyyy
To add on to what Tom said, be aware that some date string formats are ambiguous. '02/11/2015' could be interpreted as either February 11 or November 2.Answered | 4 Replies | 7786 Views | Created by brucey54 - Monday, November 2, 2015 1:45 PM | Last reply by Tom Phillips - Monday, November 2, 2015 3:49 PM -
0 Votes
Date Format DD/MM/YYYY
Format(Parameters!Answered | 4 Replies | 6716 Views | Created by Fabrizzio Caputo - Wednesday, March 30, 2011 6:19 PM | Last reply by Fabrizzio Caputo - Wednesday, March 30, 2011 6:30 PM -
1 Votes
changing date format from yyyy/mm/dd to mm/dd/yyyy
Actually you code does not convert that string to a string of "yyyy/mm/dd", it converts the value to a DATE.Answered | 5 Replies | 1750 Views | Created by al.sallam - Thursday, April 10, 2014 6:23 PM | Last reply by al.sallam - Thursday, April 10, 2014 8:12 PM -
1 Votes
Convert the date of string to datetime format 'MM/dd/yyyy' when the system date format is 'dd/MM/yyyy'.
I need to pass this selected date as sql query parameter in datetime format of "MM/dd/yyyy" when the system's date ...Answered | 6 Replies | 25833 Views | Created by Ragunaathan M P - Thursday, February 5, 2015 4:19 AM | Last reply by Viorel_ - Thursday, February 5, 2015 9:49 AM -
0 Votes
MM/DD/YYYY Format
we are getting date format like MM/DD/YYYyAnswered | 3 Replies | 10407 Views | Created by vamsi1980 - Monday, June 4, 2012 4:34 PM | Last reply by vamsi1980 - Tuesday, June 5, 2012 8:48 AM -
1 Votes
Format date to show dd/mm/yyyy in Infopath
(only with two controls) although I change the Region settings of site and PC settings to Engliish(Australia).and when select date from other date picker ...Answered | 6 Replies | 26378 Views | Created by Venkatzeus - Monday, January 24, 2011 2:31 PM | Last reply by ooodrey7 - Saturday, September 15, 2012 8:59 AM -
1 Votes
Converting datepicker date to YYYY-MM-DD format?
Try this // Set the Format type and the CustomFormat string.Answered | 1 Replies | 23986 Views | Created by clbassett03 - Tuesday, October 1, 2013 7:14 PM | Last reply by PaulDAndrea - Tuesday, October 1, 2013 7:20 PM -
2 Votes
format date time to string dd/MM/yyyy
The following code works, I have tested it: DateTime time = DateTime.Now; string ComputeStartDate = time.ToString("dd/MM/yyyy", ...Answered | 8 Replies | 51177 Views | Created by airwalker2000 - Monday, June 9, 2014 10:34 AM | Last reply by LuinkCL - Tuesday, July 24, 2018 3:28 PM -
1 Votes
Insert DATE to database (format 'YYYY-MM-DD')
The date in my textbox is in this format mm/dd/yyyy.Answered | 6 Replies | 77508 Views | Created by MiCzZz - Friday, August 27, 2010 11:47 AM | Last reply by MiCzZz - Saturday, August 28, 2010 12:22 AM -
0 Votes
Date Format - Varchar MMDDYYYY to DD/MM/YYYY
Here's an idea DECLARE @tblData TABLE (EffDt VARCHAR(15)) INSERT INTO @tblData values ('06172020') INSERT INTO @tblData values ('05152020') INSERT INTO ...Answered | 4 Replies | 1647 Views | Created by sqldba20 - Friday, June 26, 2020 1:55 PM | Last reply by Wild.Bill - Friday, June 26, 2020 5:24 PM -
1 Votes
Date Format Help - yyyy-mm-dd to CCYYMMDD
Century is treated as an implicit part of the Year so the two most common Year formats would be YY and YYYY.Answered | 7 Replies | 8119 Views | Created by sukra1234 - Wednesday, October 19, 2016 9:45 PM | Last reply by Johns-305 - Thursday, October 20, 2016 2:42 PM -
2 Votes
Change Date Format to DD/MM/YYYY
In query you can use convert() function to format date to desired view or just split datetime into pieces and concatenate them together like this: declare ...Answered | 2 Replies | 4353 Views | Created by Sam233 - Tuesday, June 22, 2010 11:28 AM | Last reply by Oleksandr Klymenko - Tuesday, June 22, 2010 11:43 AM -
0 Votes
Date format "dd/MM/yyyy" in TextBox
in format ""dd/mm/yyyy""", "Error", MessageBoxButtons.OK, MessageBoxIcon.Answered | 3 Replies | 9154 Views | Created by Shahed Ali - Wednesday, November 23, 2011 4:07 AM | Last reply by dbasnett - Wednesday, November 23, 2011 12:31 PM -
2 Votes
how to check entered date is in dd/mm/yyyy format ????
are you trying to check for an exact format (dd/MM/yyyy) or just a valid date.Answered | 4 Replies | 3212 Views | Created by Naeem Akhtar - Monday, October 20, 2008 11:27 AM | Last reply by dbasnett - Monday, October 20, 2008 1:32 PM -
0 Votes
Converting dd-mm-yyyy to mm-yyyy
=DATE(MID(A2,7,4),MID(A2,4,2),MID(A2,1,2)) dd/mm/yyyy to mm/dd/yyyyAnswered | 6 Replies | 27114 Views | Created by Mark Bristoll - Saturday, November 26, 2011 6:13 AM | Last reply by AnshumanKr - Tuesday, December 26, 2017 7:19 PM -
1 Votes
Format the date in varchar type to mm/dd/yyyy
MS Sql Server has MANY ways to return dates and times formatted as you want so depending on what you want to see and how you want to see it having the ...Answered | 5 Replies | 1176 Views | Created by hypeonfire - Wednesday, February 18, 2015 3:01 PM | Last reply by TiborK - Wednesday, February 18, 2015 3:48 PM -
1 Votes
Date format "MM/DD/YYYY" not sorting correctly
Your_Date_Field.Value), "yyyy-MM-dd") The CDate might not be required in case Your_Date_Field comes out of the query as datetime data type.Answered | 11 Replies | 10083 Views | Created by AUtfsAdmin - Monday, August 17, 2015 6:20 PM | Last reply by Vaclav Jansa - Thursday, August 20, 2015 1:18 PM -
3 Votes
mm/dd/yy to mm/dd/yyyy
Help me.I have a situation to convert mm/dd/yy to mm/dd/yyyy when somebody enters date.Answered | 11 Replies | 9816 Views | Created by susheel1347 - Monday, October 7, 2013 11:24 PM | Last reply by Kalman Toth - Tuesday, October 8, 2013 8:32 AM -
0 Votes
convert date string from yyyy/MM/dd format to datetime yyyy/MM/dd format
Use the ToString overload that takes the format and an IFormatProvider: string format = ...Answered | 3 Replies | 29330 Views | Created by Bouki - Wednesday, June 10, 2015 8:01 AM | Last reply by Magnus (MM8) - Wednesday, June 10, 2015 1:39 PM - Items 1 to 20 of 1452076 Next ›
No announcements
