Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » CalendarCtrl » DateTimeCtrl 1.06 released
Re: DateTimeCtrl 1.06 released [message #4584 is a reply to message #4580] Tue, 15 August 2006 23:20 Go to previous messageGo to previous message
Werner is currently offline  Werner
Messages: 234
Registered: May 2006
Location: Cologne / Germany
Experienced Member
unodgs wrote on Tue, 15 August 2006 22:37

Yes you're right. I just used method appropriate for europe (I think so, I'm not an expert in this topic...).
The only problem is to find proper algorithms for method:

WeekOfYear(int day, int month, int year)

if you know them please mail them to me.

I will also add ability to choose what day of week is first monday or sunday - in one of next versions..


I'll look around. In a rush I only found the following spreadsheet formula to calculate the week of a year from a date in cell A1 according to ISO 8601:

TRUNCATE((A1-DATE(YEAR(A1-REST(A1-2;7)+3);1;REST(A1-2;7)-9)) /7)

(I hope this is clear. I had to translate the formula from German to English. And I even didn't test it Rolling Eyes )

Werner

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: [EXISTS] DateTimeCtrl
Next Topic: DateTimeCtrl in new versions U++
Goto Forum:
  


Current Time: Tue May 07 14:07:31 CEST 2024

Total time taken to generate the page: 0.02602 seconds