Mendix 7 is no longer supported unless you have Extended Support (for details, please contact Mendix Support). Mendix 7 documentation will remain available for customers with Extended Support until July, 2024.

Trim to Date

Last modified: February 3, 2023

1 Introduction

These are functions to round off dates to different time units.

2 trimToSeconds

Trim the date to seconds, rounding off all milliseconds to zero.

2.1 Input Parameters

  • The date that should be trimmed
  • Type: DateTime

2.2 Output

  • The same date, only rounded down to seconds
  • Type: DateTime

2.3 Example

Assume a variable $myDate that represents ‘08-06-2008 10:12:51.387’:

1

trimToSeconds($myDate)

returns:

1

'Sun Jun 08 10:12:51 CEST 2008'

3 trimToMinutes

Trim the date to minutes, rounding off all (milli)seconds to zero.

3.1 Input Parameters

  • The date that should be trimmed
  • Type: DateTime

3.2 Output

  • The same date, only rounded down to minutes
  • Type: DateTime

3.3 Example

Assume a variable $myDate that represents ‘08-06-2008 10:12:51’:

1

trimToMinutes($myDate)

returns:

1

'Sun Jun 08 10:12:00 CEST 2008'

4 trimToHours[UTC]

Trim the date to hours, rounding off all minutes to zero.

trimToHours uses the user’s time zone, and trimToHoursUTC uses the UTC time zone.

4.1 Input Parameters

  • The date that should be trimmed
  • Type: DateTime

4.2 Output

  • The same date, only rounded down to hours
  • Type: DateTime

4.3 Example

Assume a variable $myDate that represents ‘08-06-2008 10:12:51’:

1

trimToHours($myDate)

returns:

1

'Sun Jun 08 10:00:00 CEST 2008'

5 trimToDays[UTC]

Trim the date to days, rounding off all hours to zero.

trimToDays uses the user’s time zone, and trimToDaysUTC uses the UTC time zone.

5.1 Input Parameters

  • The date that should be trimmed
  • Type: DateTime

5.2 Output

  • The same date, only rounded down to days
  • Type: DateTime

5.3 Example

Assume a variable $myDate that represents ‘08-06-2008 10:12:51’:

1

trimToDays($myDate)

returns:

1

'Sun Jun 08 00:00:00 CEST 2008'

6 trimToMonths[UTC]

Trim the date to months, rounding off all days to zero.

trimToMonths uses the user’s time zone and trimToMonthsUTC uses the UTC time zone.

6.1 Input Parameters

  • date that should be trimmed
  • Type: DateTime

6.2 Output

  • The same date, only rounded down to months
  • Type: DateTime

6.3 Example

Assume a variable $myDate that represents ‘08-06-2008 10:12:51’:

1

trimToMonths($myDate)

returns:

1

'Sun Jun 01 00:00:00 CEST 2008'

7 trimToYears[UTC]

Trim the date to years, rounding off all months and days to zero.

trimToYears uses the user’s time zone, and trimToYearsUTC uses the UTC time zone.

7.1 Input Parameters

  • The date that should be trimmed
  • Type: DateTime

7.2 Output

  • The same date, only rounded down to years
  • Type: DateTime

7.3 Example

Assume a variable $myDate that represents ‘08-06-2008 10:12:51’:

1

trimToYears($myDate)

returns:

1

'Tue Jan 01 00:00:00 CEST 2008'