Forum Discussion
beaverbuzz85
3 years agoRegular Visitor
Troubleshooting Simple Conversion of String to Date
Hello, I am trying to solve a seemingly simple issue. I am trying to convert the following to a year. 1999/2000 to 2000. 1999/2000 (string) My calculated column is this: Tax Year...
FreemanZ
Super User
3 years agoDate format needs the complete set of YYYY-MM-DD, but you only have YYYY. You can set it as text.
beaverbuzz85
3 years agoRegular Visitor
Thanks for the clarification.
I understand that you can't forecast with a basic line chart while the x-axis is text (i.e. the supposed year as you have described).
Could you please confirm?