I was wondering how can I just show the days from any given date?
Solved
Isolate the days from a date
+9Best answer by Ron_Daniel
@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")
+31I'm not sure I follow I'm afraid. Any chance you could provide an example or two?
+21@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')
+9Thank 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."
+21@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")
+9@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!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.