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?
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |