Is it possible to obtain month and day information from a given date field?

Is it possible to obtain month and day information from a given date field?

Yes, you can use the Deluge date function getDay() and getMonth() to obtain the day and month information.

- getDay() returns the numerical day of the month for a particular year. The value returned will be between 1 and 31.
- getMonth() returns the numerical month of the year. The value returned is between 1 and 12.

Usage:
<date>.getDay()
<date>.getMonth()

where, <date> is a form field of type "date".

Refer here for more information on the other available Deluge date-time functions.

    • Related Articles

    • Date-field Autoresponder

      Understanding date-field autoresponder Date-field based autoresponders are a series of automated messages that are sent to contacts based on the date in the date field associated with them. Wishing customers happy birthdays and anniversaries are ...

    • I would like to order the DOB field in my form, based on month and day. How can I do this?

      To sort records based on custom value acquired from the DOB field i.e., month and day, you may add a formula field with below suggested sample expression, ((((((DOB.getMonth() / 100).round(2))) + "").getSuffix(".")) + "-") + ((((DOB.getDay() / ...

    • How can I calculate the age of a person from a given Date of Birth?

      To calculate the age of a person from a give DOB, add a Formula field and specify the formula expression as given below: ((zoho.currentdate - DOB) / (1000 * 3600 * 24 * 365)).round(2)  Note:  If you use a Formula field, the calculated age can be seen ...

    • How do I Filter Views based on Date Criteria?

      Show records that expires in the next seven days You can use the following criteria in your view to fetch records ending in the next 7 days, based on the Expiry date in the form. In the sample code given below, Expiry is the name of the date field in ...

    • How can I add days to a date field?

      You can manipulate a date field by using the + (to add) and - (to subtract) Operators or by using the Built-in date functions. For example, if you would like to add 364 days to a particular date field, say StartDate and display it in another field, ...