DAY Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The DAY function returns the corresponding day of the month as a number between 1 and 31. | The DAY function returns the corresponding day of the month as a number between 1 and 31. | ||
''Format:'' | ''Format:'' | ||
'''DAY(Column name or string with date)''' | '''DAY(Column name or string with date)''' | ||
| Line 14: | Line 16: | ||
*[[Calculated fields]] | *[[Calculated fields]] | ||
*[[Reports]] | *[[Reports]] | ||
*[[Feature Description]] | |||
Latest revision as of 05:28, 21 January 2020
The DAY function returns the corresponding day of the month as a number between 1 and 31.
Format:
DAY(Column name or string with date)
Example:
IF(DAY(B)=7;"7thday of the month";"")