Only takes the date

image
Hi…
How do I retrieve just the date, I’m sure I’ve seen a similar issue, but I can’t find it.
example 15 jan 2023, I only want to take the date “15”

Thank You

Use a Math column:

DAY(T) with T being the “Date Time” column you show in the screenshot.

3 Likes

Thank You @ThinhDinh
it worked…

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.