Built-in Constants


System.DayOfWeek

System.DayOfWeek.Sunday (0) 
System.DayOfWeek.Monday (1)
System.DayOfWeek.Tuesday (2)
System.DayOfWeek.Wednesday (3)
System.DayOfWeek.Thursday (4)
System.DayOfWeek.Friday (5)
System.DayOfWeek.Saturday (6)

System.Globalization.DateTimeStyles




Microsoft.VisualBasic.DateFormat

This is an enumeration and corresponds to VBA.vbDateTimeFormat

Microsoft.VisualBasic.DateFormat.GeneralDate (0) 
Microsoft.VisualBasic.DateFormat.LongDate (1)
Microsoft.VisualBasic.DateFormat.LongTime (2)
Microsoft.VisualBasic.DateFormat.ShortDate (3)
Microsoft.VisualBasic.DateFormat.ShortTime (4)

Microsoft.VisualBasic.DateInterval

There is no VBA equivalent.

Microsoft.VisualBasic.DateInterval.Day (4) 
Microsoft.VisualBasic.DateInterval.DayOfYear (3)
Microsoft.VisualBasic.DateInterval.Hour (7)
Microsoft.VisualBasic.DateInterval.Minute (8)
Microsoft.VisualBasic.DateInterval.Month (2)
Microsoft.VisualBasic.DateInterval.Quarter (1)
Microsoft.VisualBasic.DateInterval.Second (9)
Microsoft.VisualBasic.DateInterval.Weekday (6)
Microsoft.VisualBasic.DateInterval.WeekOfYear (5)
Microsoft.VisualBasic.DateInterval.Year (0)

Microsoft.VisualBasic.FirstDayOfWeek

This is an enumeration and corresponds to VBA.vbDayOfWeek

Microsoft.VisualBasic.FirstDayOfWeek.System (0) 
Microsoft.VisualBasic.FirstDayOfWeek.Sunday (1)
Microsoft.VisualBasic.FirstDayOfWeek.Monday (2)
Microsoft.VisualBasic.FirstDayOfWeek.Tuesday (3)
Microsoft.VisualBasic.FirstDayOfWeek.Wednesday (4)
Microsoft.VisualBasic.FirstDayOfWeek.Thursday (5)
Microsoft.VisualBasic.FirstDayOfWeek.Friday (6)
Microsoft.VisualBasic.FirstDayOfWeek.Saturday (7)

Microsoft.VisualBasic.FirstWeekOfYear

This is an enumeration and corresponds to VBA.vbFirstWeekOfYear

System (0) 
Jan1 (1)
FirstFourDays (2)
FirstFullWeek (3)

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext