Tony Diaz Posted October 12, 2020 Share Posted October 12, 2020 My JSON data contains dates in one of three formats: YYYY YYYY-MM YYYY-MM-DD The field is: Items::Initial_Release Instead of the text, I would like to have it display that as a proper date based on what's there. 1984: Year Only 1984-08: August, 1984 1984-08-08: 08 August, 1984 Based on the available options for formatting the date, I gather that the FileMaker Date format probably can't deal with less than the full amount of data? Or even changing it, having it be Day first if there is full data, otherwise Year, or Year, Month only. Otherwise, it looks like I would have to have the date field in three different formats and use Hide If .. the data is 4 characters, 7 characters, or 10 characters? As well, no matter what I do with those format settings above, I can't enter anything less than 10 characters in the field if it's defined as a date field. I'd like to be able to get things by date in queries, so keeping it as date format would seem to be the better way to make that work. Link to comment Share on other sites More sharing options...
This topic is 958 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now