DAY Function: Difference between revisions

From Planfix
Jump to: navigation, search
 
No edit summary
Line 1: Line 1:
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";"")
== Go To ==
== Go To ==
*[[Standard functions | Standard operators and Planfix functions]]
*[[Standard functions | Standard operators and Planfix functions]]
*[[Calculated fields]]
*[[Calculated fields]]
*[[Reports]]
*[[Reports]]

Revision as of 04:32, 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";"")


Go To