Isolate the days from a date

[Nathan_Ramey]

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

[TheTimeSavingCo]

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

[Ron_Daniel]

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

[Nathan_Ramey]

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 · Accepted solution]

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

[Nathan_Ramey]

Thank you!