Date year changing to 2001 in details view on interactive dashboard

[Greg_Korte]

I have a date field in a table, and when I check the data in the table view the dates are correct, however, in the details view for that table the dates are all changing to the year 2001. Has anyone been experiencing this issue?

Thanks in advance!

[Steve]

Can you post a screenshot or shots demonstrating the inconsistency?

[Greg_Korte]

Here’s the data table:

This is the test data:

And here is the view:

[Steve]

What does the value look like as stored in your spreadsheet? Does it include the full four-digit year?

[Greg_Korte]

The value does include the four digit year, yes. I also just cleared the formatting in case something was funky there. Same result.

[Steve]

I’m afraid I have no idea what’s going on! Perhaps best to engage support@appsheet.com, as this is likely a bug. Please let us know here what they find!

[Greg_Korte]

Will do. Thanks for your help!

[Greg_Korte · Accepted solution]

Tables & slices & views oh my!

So here’s how I bungled this…

The date column in question was a referenced date from another table. I truncated the year for a separate view as text because we only need to use the month and date for this particular view. So, in the details view I was asking for a date type object without a year, and I’m assuming because a date object probably defaults to having a year I got 2001.

I fixed it by setting up another VC, this one still referencing the other table for the date but set to TEXT instead of DATE and then using the unmodified DATE in the details view. Things seem to be working as expected now.

Thanks again for rubber ducking with me!