here is the thing that...
one of my column have 2 possible data types
either <date> or <longtext>
is there anyway to set 2 data types for certain column?
plz I’m stuck here.
Nope
Curious why you need two data types for one col...
Anyway you probably just have to settle for LONGTEXT and use EXTRACTDATES or other text manipulation to get dates to process.
I am not talking about the data type of the columns, but the schema settings of the table.
Perhaps you prepare 3 columns and process them as follows.
* Yes/No Type
* Date type
* Required if [Need an Expiration date] is true.
* longtext type
* Required if [Need an Expiration date] is false.
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
17 |