Text to Date I would like to know what the c...

Colin1
New Member

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?

0 4 330
4 REPLIES 4
Top Labels in this Space