DatePart Function

The DatePart function returns a specified part of a date value. In other words, this function can part out the year, month, day, hour, or minute of a date value. A good use case is using the DatePart function and the Now function to always show the current year for the copyright year in the footer. Not to be confused with the DateParse function.



1 = Date value to retrieve a specified part (can be a variable). Valid values include ‘MM/dd/yyyy’ or ‘YYYY-MM-DD’
2 = Unit of time specified. Valid values include ‘Y’ (year), ‘M’ (month), ‘D’ (day), ‘H’ (hour), ‘MI’ (minute)




var @date, @year
set @date = Now()
set @year = DatePart(@date,”y”)

Copyright © %%=v(@year)=%%



Copyright © 2021


Using the DatePart function in conjunction with the Now function, the current year can be retrieved and returned. The unit time of difference used in this example is “Y” which returns the year so that the copyright year will not need to be updated every year.

Leave a Reply

Your email address will not be published. Required fields are marked *