BuildCurDate()

BuildCurDate is a function within ddGlobal and forms part of the ddDate suite of macros.  The macro is straight forward and will use the current date (today), using the excel formula +now() and convert it into the text format YYYY-MM.

=+BuildCurDate()

If I run this now, I will get the answer “2013-03″.

Please note that it uses the function “CleanDate” as discussed in another post.

Function BuildCurDate() As String
'Function that will build the current date in the format YYYY-MM
'Written by Denis
    BuildCurDate = Year(Now) & "-" & Month(Now)
    BuildCurDate = CleanDate(BuildCurDate)
End Function