Help on Copy/Paste for DateTimePicker

[OriginalGriff]

How are you copying? How are you pasting? Show the relevant code fragments!

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!

[manju 3]

I have not added any code specific for copy paste. I have just changed the property of DateTimePicker is.dateTimePicker.CustomFormat = "dd/MM/yy HH:mm:ss"; is.dateTimePicker.Format = System.Windows.Forms.DateTimePickerFormat.Custom; is.dateTimePickerExecTime.ShowUpDown = true; Once right click on Control I select on Copy it copies and I copy it in excel . From excel I again copy and trying to paste it on control.

[OriginalGriff]

Well what did you expect to happen? You copy a date in a non-standard form, paste it into a spreadsheet (which identifies it as a date and converts it to a DateTime object), then you copy that datetime object from Excel (in standard-for-that-PC format), and paste it back onto a control that doesn't expect standard format. There isn't a whole lot that we can do to prevent that causing a problem! :laugh:

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!

[manju 3]

Yes. Copy in DD/MM/YY format and paste the same in spreadsheet. Edit the DateTime in spreadsheet. Copy from spreadsheet and paste back to the DateTime control. But DateTime control allows MM/DD/YY format. That's the issue :(

[OriginalGriff]

And I'm confused about what you think we can do about a user input problem like that!

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!

[Richard Deeming]

A simple solution: display your UI to your users using their preferring culture settings. We're all quick to complain when Microsoft products ignore our settings and display dates in US format; so why should our applications be exempt? For extra points, use an unambiguous format like dd-MMM-yyyy. Standard Date and Time Format Strings | Microsoft Docs[^] Custom Date and Time Format Strings | Microsoft Docs[^]

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

[Lost User]

Your idea of "paste" may not correspond to the reality of the situation. Sometimes you can use "windows paste commands"; at other times, you need to interect with the "clip board", reformat, copy (not "paste") to a property of the TextBox; etc. i.e. "programming".

"(I) am amazed to see myself here rather than there ... now rather than then". ― Blaise Pascal

[manju 3]

Thanks for all your responses Is there a way where I can change the .MaxValue Property? Presently it displays in MM/DD/YYYY(12/31/9999 11:59 PM). Can I set it to DD/MM/YYYY(31/12/1999).

[manju 3]

Do we have any event for Paste where I can trigger and reformat the Date and paste it in the control ?

[Lost User]

You didn't specify WPF, Windows Forms or ASP.NET or ... If you're going to use a "date picker", you need to "learn it" before "looking around" for "other" solutions. This may help; also note the reference to "system settings". [c# - Getting date from DatePicker in format yyyy/MM/dd - Stack Overflow](https://stackoverflow.com/questions/14002425/getting-date-from-datepicker-in-format-yyyy-mm-dd)

"(I) am amazed to see myself here rather than there ... now rather than then". ― Blaise Pascal

[manju 3]

Thank you for your suggestions. I have achieved it using ParseExact function with some formatting the DateTime value. Thanks Sharan