@Day (Formula Language)

Extracts the day of the month from the specified date.


@Day( timeDateValue )



Time-date or time-date list. The date containing the day value that you want to extract.

Return value


Number or number list. The number corresponding to the day of the month indicated by timeDateValue. Returns -1 if the time-date provided contains only a time value and not a date.


If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.


  1. This example returns 15 if today is July 15, August 15, September 15, and so on.
  2. This example returns 20 and 21 in a list.
    @Day([11/20/95 8:58:12] : [11/21/95 8:58:12])
  3. This example returns the string "Payment received on or before the 15th" if the PaymentReceived field is filled in on or before the 15th of the month; otherwise, it returns the string "Payment received after the 15th."
    @If(@Day(PaymentReceived)<16;"Payment received on or before the 15th";"Payment received after the 15th")