# Isolate the days from a date

Topic Labels: Formulas
Solved
714 5
cancel
Showing results for
Did you mean:
6 - Interface Innovator

I was wondering how can I just show the days from any given date?

1 Solution

Accepted Solutions
7 - App Architect

@Nathan_Ramey thanks for clarifying! In that case, you just need this formula:

DATETIME_FORMAT(Date, "DD")
or, if you don't want the leading zero on single-digit days, then
DATETIME_FORMAT(Date, "D")
5 Replies 5
16 - Uranus

I'm not sure I follow I'm afraid.  Any chance you could provide an example or two?

7 - App Architect

@Nathan_Ramey , are you asking for a date calculator, to determine how many days difference there is between today and a given date? If so, try this formula:

DATETIME_DIFF(TODAY(), {Date}, 'days')

6 - Interface Innovator

Thank you for the replies but I was looking for just a way to only see the day of the date. For example, today is the 22nd and instead of seeing 2/22/23 I only want to see just the date so just "22."

7 - App Architect

@Nathan_Ramey thanks for clarifying! In that case, you just need this formula:

DATETIME_FORMAT(Date, "DD")
or, if you don't want the leading zero on single-digit days, then
DATETIME_FORMAT(Date, "D")
6 - Interface Innovator

Thank you!