Search Results for

    Show / Hide Table of Contents

    Date & Time

    To set a specific date, you can use the constructors of the DateTime structure or the ToDateTime functions (see more details in the "Conversion") or the DateSerial function (discussed below).

    For example, to create a date and time using constructors, you can use the following code:

    new DateTime(year, month, day, hours, minutes, seconds);
    

    When using the date conversion functions from this section, the time information is by default preserved. To remove the time from the date, you can use the Format or FormatDateTime functions. More detailed information about these functions is presented in the "Formatting" section.

    As an example, the [Employees.BirthDate] field from the demonstration database will be used in the functions.

    [Employees.BirthDate] = 27.01.1986
    

    AddDays

    Function Parameters Return value
    AddDays DateTime date, double value DateTime

    Adds the specified number of days (value) to the date date and returns a new date.

    Example:

    AddDays(new DateTime(2024,4,2), 2) = 4/4/2024 12:00:00 AM
    AddDays(ToDateTime("4/2/2024"), 2) = 4/4/2024 12:00:00 AM
    AddDays([Employees.BirthDate], 2) = 1/29/1986 12:00:00 AM
    

    AddHours

    Function Parameters Return value
    AddHours DateTime date, double value DateTime

    Adds the specified number of hours (value) to the date date and returns a new date.

    Example:

    AddHours(new DateTime(2024,4,2,5,30,5), 1) = 4/2/2024 6:30:05 AM
    AddHours(ToDateTime("4/2/2024 5:30:05"), 1) = 4/2/2024 6:30:05 AM
    AddHours([Employees.BirthDate], 1) = 1/27/1986 1:00:00 AM
    

    AddMinutes

    Function Parameters Return value
    AddMinutes DateTime date, double value DateTime

    Adds the specified number of minutes (value) to the date date and returns a new date.

    Example:

    AddMinutes(new DateTime(2024,4,2,5,30,5), 10) = 4/2/2024 5:40:05 AM
    AddMinutes(ToDateTime("4/2/2024 5:30:05"), 10) = 4/2/2024 5:40:05 AM
    AddMinutes([Employees.BirthDate], 10) = 1/27/1986 12:10:00 AM
    

    AddMonths

    Function Parameters Return value
    AddMonths DateTime date, int value DateTime

    Adds the specified number of months (value) to the date date and returns a new date.

    Example:

    AddMonths(new DateTime(2024,4,2,5,30,5), 2) = 6/2/2024 5:30:05 AM
    AddMonths(ToDateTime("4/2/2024 5:30:05"), 2) = 6/2/2024 5:30:05 AM
    AddMonths([Employees.BirthDate], 2) = 3/27/1986 12:00:00 AM
    

    AddSeconds

    Function Parameters Return value
    AddSeconds DateTime date, double value DateTime

    Adds the specified number of seconds (value) to the date date and returns a new date.

    Example:

    AddSeconds(new DateTime(2024,4,2,5,30,5), 10) = 4/2/2024 5:30:15 AM
    AddSeconds(ToDateTime("4/2/2024 5:30:05"), 10) = 4/2/2024 5:30:15 AM
    AddSeconds([Employees.BirthDate], 10) = 1/27/1986 12:00:10 AM
    

    AddYears

    Function Parameters Return value
    AddYears DateTime date, int value DateTime

    Adds the specified number of years (value) to the date date and returns a new date.

    Example:

    AddYears(new DateTime(2024,4,2,5,30,5), 3) = 4/2/2027 5:30:05 AM
    AddYears(ToDateTime("4/2/2024 5:30:05"), 3) = 4/2/2027 5:30:05 AM
    AddYears([Employees.BirthDate], 3) = 1/27/1989 12:00:00 AM
    

    DateDiff

    Function Parameters Return value
    DateDiff DateTime date1, DateTime date2 TimeSpan

    Returns the interval (number of days, hours, minutes, seconds) between two dates.

    Example:

    DateDiff(new DateTime(2024,4,2,5,0,0), new DateTime(2025,1,2,5,30,5)) = -275.00:30:05
    DateDiff(ToDateTime("1/2/2025 5:30:05"), ToDateTime("4/2/2024 5:00:00")) = 275.00:30:05
    DateDiff(ToDateTime("4/2/2024 5:00:00"), [Employees.BirthDate]) = 13945.05:00:00
    

    DateSerial

    Function Parameters Return value
    DateSerial int year, int month, int day DateTime

    Creates a new DateTime value from the specified year, month and day.

    Another available method to set a specific date.

    Example:

    DateSerial(2024,4,2) = 4/2/2024 12:00:00 AM
    

    Day

    Function Parameters Return value
    Day DateTime date int

    Gets the day of the month (1-31) represented by the specified date.

    Example:

    Day(new DateTime(2024,4,2)) = 2
    Day(ToDateTime("4/2/2024")) = 2
    Day([Employees.BirthDate]) = 27
    

    DayOfWeek

    Function Parameters Return value
    DayOfWeek DateTime date string

    Gets the localized name of the day of the week represented by the specified date.

    Example:

    DayOfWeek(new DateTime(2024,4,2)) = "Tuesday"
    DayOfWeek(ToDateTime("4/2/2024")) = "Tuesday"
    DayOfWeek([Employees.BirthDate]) = "Monday"
    

    DayOfYear

    Function Parameters Return value
    DayOfYear DateTime date int

    Gets the day of the year (1-365) represented by the specified date.

    Example:

    DayOfWeek(new DateTime(2024,4,2)) = 93
    DayOfWeek(ToDateTime("4/2/2024")) = 93
    DayOfWeek([Employees.BirthDate]) = 27
    

    DaysInMonth

    Function Parameters Return value
    DaysInMonth int year, int month int

    Returns the number of days in the specified month and year.

    Example:

    DaysInMonth(2024, 4) = 30
    

    Hour

    Function Parameters Return value
    Hour DateTime date int

    Gets the hour component (0-23) represented by the specified date.

    Example:

    Hour(new DateTime(2024,4,2,5,30,5)) = 5
    Hour(ToDateTime("4/2/2024 5:30:05")) = 5
    Hour([Employees.BirthDate]) = 0
    

    Minute

    Function Parameters Return value
    Minute DateTime date int

    Gets the minute component (0-59) represented by the specified date.

    Example:

    Minute(new DateTime(2024,4,2,5,30,5)) = 30
    Minute(ToDateTime("4/2/2024 5:30:05")) = 30
    Minute([Employees.BirthDate]) = 0
    

    Month

    Function Parameters Return value
    Month DateTime date int

    Gets the month component (1-12) represented by the specified date.

    Example:

    Month(new DateTime(2024,4,2)) = 4
    Month(ToDateTime("4/2/2024")) = 4
    Month([Employees.BirthDate]) = 1
    

    MonthName

    Function Parameters Return value
    MonthName int month string

    Gets the localized name of the specified month (1-12).

    Example:

    MonthName(1) = "January"
    

    Second

    Function Parameters Return value
    Second DateTime date int

    Gets the seconds component (0-59) represented by the specified date.

    Example:

    Second(new DateTime(2024,4,2,5,30,5)) = 5
    Second(ToDateTime("4/2/2024 5:30:05")) = 5
    Second([Employees.BirthDate]) = 0
    

    Year

    Function Parameters Return value
    Year DateTime date int

    Gets the year component represented by the specified date.

    Example:

    Year(new DateTime(2024,4,2)) = 2024
    Year(ToDateTime("4/2/2024")) = 2024
    Year([Employees.BirthDate]) = 1986
    
    Back to top © 1998-2025 Copyright Fast Reports Inc.