This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live!
So i am running around in circles for something I should know.
I have a date Field, 2019-05-22 and I want to convert it to a string like this: 22-May-2019
This should be simple right???
Yes, use the DateTimeFormat function
This should work.
I have tried it but I am getting Blanks in my output. I have tried String and V String formats...
Is your date field in Date Format?
Thansk for the quick reply
Yes the field is in date format. Then I am changing the date format to the desired as you've suggested, then I want it to be a string.
The "Field1" is in date Format.
Then I create a new field with V_WString format and use the function I mentioned.
Great example, I think because my date field is formatted as 05/22/2019 and not 2019-05-22. So I probably have to change it to the ISO standard first?
Yes, in this case you could use this formula:
DateTimeFormat(DateTimeParse([date], "%m/%d/%Y"), "%d-%b-%Y")
First you use DateTimeParse function, to change it to a Date Format
Then you use DateTimeFormat function, to bring it to a string format again.
oddly enough I was convinced that would work but it didnt. 😞
My field is:
you need to create a new field.in the Formula Tool
Example - Start_Date_Formatted