How would I create a formula for the day of the month? I currently have a VWString format setup for 2023-10-12 and I would like to add another column that only represents the 12.
Hey @heatherpaquette, you can just use the DateTimeDay() function in a Formula tool expression which isolates the day part of an ISO-formatted date:
DateTimeDay([Field])
Thank you very much, that worked great. I'm a new user so just trying to get familiar.
No problem @heatherpaquette - glad that helped! As you'll always need dates in ISO format to work with them, the day will always be the rightmost 2 characters so you could also use the following which just takes N characters from the right of the string:
Right([Field], 2)