DatePart

Overview

Returns a specified part of a date.

Syntax

DatePart(1, 2)

Function Properties

Ordinal Type Description
1 Date Required Date value used to retrieve a specified part using either MM/dd/yyyy or YYYY-MM-DD format
2 string Required The part of the date to retrieve. Valid values include Y, M, D, H, or MI

Usage

%%=Datepart('5/1/2008','year')=%%

System returns: 2008

Last Updated: Jun 8, 2021