This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

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

Posted on 03-12-2018 05:00 PM
Colin1
New Member
Reply posted on --/--/---- --:-- AM

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 379
Topic Labels
0 Likes
Reply
4 REPLIES 4
Top Labels in this Space