eirikdaude
Board Regular
- Joined
- Nov 26, 2013
- Messages
- 93
- Office Version
- 365
- Platform
- Windows
I want to use VBA to capitalize the first letter of a formatted date. To give an example, when I put
into the immediate window, I want it to output "Sø.", but what I get is "sø.". In a perfect world I'd want it to be a three-letter truncation instead of having the period at the end, but that's not as much of a deal as the first letter being lowercase.
Whether format or some other function is used for the task doesn't matter, but I don't want to need an intermediary step, ideally.
VBA Code:
? format(#1/1/2023#, "Ddd", vbMonday, vbFirstFourDays)
into the immediate window, I want it to output "Sø.", but what I get is "sø.". In a perfect world I'd want it to be a three-letter truncation instead of having the period at the end, but that's not as much of a deal as the first letter being lowercase.
Whether format or some other function is used for the task doesn't matter, but I don't want to need an intermediary step, ideally.