Text to Date
I would like to know what the correct expression is to convert text to date please?
I have a Virtual Column of a date type.
I have a Application Formula like this:
CONCATENATE([REPORT_DAY], “/”, [REPORT_MONTH], “/”, [REPORT_YEAR])
REPORT_DAY, REPORT_MONTH, REPORT_YEAR are of the type number in a table.
How do I make this valid to become a date please?
Give this syntax a shot in appsheet support.google.com - DATE - Docs editors Help DATE - Docs editors Help support.google.com
Not sure if it’s supported
What happens when you use the formula you provided?
Just use MM/DD/YYYY format and concatenate works; for example you can set this as an initial value of March 13, 2018 for a date column:
CONCATENATE(“03/”,“13/”,“2018”)
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |