Help

Re: Isolate the days from a date

Solved
Jump to Solution
1762 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nathan_Ramey
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

@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")
Screen Shot 2023-02-22 at 11.49.03 AM.png

See Solution in Thread

5 Replies 5

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

Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

@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')

Screen Shot 2023-02-21 at 4.08.09 PM.png


Nathan_Ramey
6 - Interface Innovator
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."

Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

@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")
Screen Shot 2023-02-22 at 11.49.03 AM.png

Thank you!