Solved: How set values without expiration date? - Page 2

DaGi07 · 05-19-2021 04:17 PM

Hello to everyone,
I have a little problem with the data type. In particular, I have a list of certificate of training course but some course have a expiration date and other no. The problem is for the certificate without expiration date because in app view appears “invalid date” where in DB is set the values “NO”. How can I show in the app that for some certificate there is no expiration date instead of “invalid date”

TKS in advance!

Arnaud_Bouchera

@DaGi07 Could you achieve your goal using a virtual column instead of the real one?

Database
To start with, I would definitely not mess with the database (see @Steve ). “No” is a no-no as a date. That said, a blank value would be perfectly fine to convey the fact that the expiration date is not set.

Slice
If the need is to filter out the invalid dates, then a slide would indeed do the job. But again, just leave these dates blank.

Display
Otherwise, if you actually want to show all dates, including the blank one, but display No instead of [blank] like it is in your chart, you could try using a virtual column for instance.

Let’s call it [VirtualDate], and make it of type Text (not Date). It would display the actual date if set, or ‘NO’ if blank.

The formula could look like:

IF ( ISBLANK( [Date] ), “No”, [Date] )

Not sure it would sort properly in the chart, but it definitely would show “No” instead of “[blank]”. Just an idea, trying to work around your issue.

View solution in original post