Skip to main content

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

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

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




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."

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

Thank you!

Reply


Terms & Conditions