I have column date type. If I insert DATE(“19/3/1988”) to Initial Value nothing appear in the column in the form for that column. Please help me why appear nothing.
@your_EMS
Provided you have a date type column, you don’t need to enter an initial value with a DATE(…) expression. You can directly type it in MM/DD/YYYY format without any quotes.
Note carefully what @LeventK said: MM/DD/YYYY. Month first, then day, then year. That ordering is required.
In addition to @Steve, if that March 3rd, 1988 is a fixed date that you shall enter as an initial value, thought not tested, you can try with this:
DATE(
TEXT("19/3/1988", "MM/DD/YYYY")
)
Solved. Thank you everyone.
You’re welcome
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |