Is there a way to find the year Today and The Week nr. today in Ilogic

[Darkforce_the_ilogic_guy]

I want to make an ilogic code that open an excel doc.. when the neweste doc always is in an folder call the current year and the excel doc is call the week nr. 

how do I get the years and week nr in ilogic 

[marcin_otręba · Accepted solution]

MessageBox.Show(DatePart("ww", Today, vbSunday), "Title")
MessageBox.Show( Today.Year, "Title")

[WCrihfield]

'General Date Format Example
Dim oGenDate As Date = FormatDateTime(Now, DateFormat.GeneralDate)

'Long Date Format Example
Dim oLongDate As Date = FormatDateTime(Now, DateFormat.LongDate)

'Long Time Format Example
Dim oLongTime As Date = FormatDateTime(Now, DateFormat.LongTime)

'Short Date Format Example
Dim oShortDate As Date = FormatDateTime(Now, DateFormat.ShortDate)

'Short Time Format Example
Dim oShortTime As Date = FormatDateTime(Now, DateFormat.ShortTime)

[WCrihfield]

Also when you type in something line 'Now' or 'Today' or 'Date' in the iLogic Rule Editor, then the dot right after it, you can see all the available options available under it.

Here's a fairly good tip for the week number of the year, too.

Get the week number of the year counting from a given date in vb 

[WCrihfield]

@Darkforce_the_ilogic_guy 

Forgot to mention, that you'll need specify (Imports System.Globalization) in the header of the iLogic rule to use the method shown in the StackOverFlow example.  See below simplified example.

Imports System.Globalization

Dim oDFI = DateTimeFormatInfo.CurrentInfo
Dim oCal = oDFI.Calendar
Dim oWeekOfYear = oCal.GetWeekOfYear(Now, oDFI.CalendarWeekRule, vbSunday)
MsgBox(oWeekOfYear,vbOKOnly," ")