אופיס 365 פונצקיה שעון קיץ

[נדמ]

מישהו מכיר פונקציה באקסס שמחזירה ערך האם השעה של המחשב היא לפי שעון קיץ או לא?

 

[moishy]

הנה פונקציה המחזירה מספרים בהתאם למצב שעון קיץ של המערכת.
0 = לא זוהה השעון
1 = שעון חורף
2 = שעון קיץ

Option Explicit
Option Compare Text

Private Type SYSTEMTIME
    wYear As Integer
    wMonth As Integer
    wDayOfWeek As Integer
    wDay As Integer
    wHour As Integer
    wMinute As Integer
    wSecond As Integer
    wMilliseconds As Integer
End Type

Private Type TIME_ZONE_INFORMATION
    Bias As Long
    StandardName(0 To 31) As Integer
    StandardDate As SYSTEMTIME
    StandardBias As Long
    DaylightName(0 To 31) As Integer
    DaylightDate As SYSTEMTIME
    DaylightBias As Long
End Type

Public Enum TIME_ZONE
    TIME_ZONE_ID_INVALID = 0
    TIME_ZONE_STANDARD = 1
    TIME_ZONE_DAYLIGHT = 2
End Enum

Private Declare Function GetTimeZoneInformation Lib "kernel32" _
                                                (lpTimeZoneInformation As TIME_ZONE_INFORMATION) As Long

Function DaylightTime() As TIME_ZONE
    Dim TZI As TIME_ZONE_INFORMATION
    Dim DST As TIME_ZONE
    DST = GetTimeZoneInformation(TZI)
    DaylightTime = DST
End Function

 

[נדמ]

תודה רבה!

איפה מוצאים את כל הפונקציות האלו?

 

[moishy]

והנה אפשרות נוספת המחזירה True בשעון קיץ וFalse בשעון חורף.

Private Const TIME_ZONE_ID_DAYLIGHT As Long = 2
Private Const TIME_ZONE_ID_INVALID As Long = &HFFFFFFFF
Private Const TIME_ZONE_ID_STANDARD As Long = 1
Private Const TIME_ZONE_ID_UNKNOWN As Long = 0

Private Type SYSTEMTIME
    wYear As Integer
    wMonth As Integer
    wDayOfWeek As Integer
    wDay As Integer
    wHour As Integer
    wMinute As Integer
    wSecond As Integer
    wMilliseconds As Integer
End Type

Private Type TIME_ZONE_INFORMATION
    Bias As Long
    StandardName(0 To 31) As Integer
    StandardDate As SYSTEMTIME
    StandardBias As Long
    DaylightName(0 To 31) As Integer
    DaylightDate As SYSTEMTIME
    DaylightBias As Long
End Type

Private Declare Function GetTimeZoneInformation Lib "kernel32" ( _
                                                lpTimeZoneInformation As TIME_ZONE_INFORMATION) As Long

Public Function IsDSTNow() As Boolean
    Dim TZI As TIME_ZONE_INFORMATION
    Dim Res As Long
'    IsDSTNow = GetTimeZoneInformation(TZI) = TIME_ZONE_ID_DAYLIGHT
    Res = GetTimeZoneInformation(TZI)
    If Res = TIME_ZONE_ID_DAYLIGHT Then
        IsDSTNow = True
    Else
        IsDSTNow = False
    End If
End Function

 

[moishy]

http://www.cpearson.com הוא אוצר בלום ממש.