Hi Community!!!
I just accidentally input 1-Jan-1925 instead of 2025 in a cell with date as data type, and now I couldn’t find that record because 2025 is set in page selector . How can I restrict users from adding dates that aren't possible? Snip below is what I am currently seeing in Pigment which shows a lot of old dates that won’t be used.
Thank you!
Neo
Hi
To make sure you are using a date that is within your calendar, I would enable the Day dimension (From the Calendar settings). Then, in your metric instead of Date, I would use this dimension Day as Data Type. You could play around the default display to see the date format you want. The caveat will be you don’t have a calendar view where you first select the year, month, day but you will type the actual date you are looking for.
Additionally, if you expand your calendar later on, new dates will become available.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.