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

[Colin1]

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?

[Grant_Stead]

Give this syntax a shot in appsheet support.google.com - DATE - Docs editors Help DATE - Docs editors Help support.google.com

[Grant_Stead]

Not sure if it’s supported

[Steven_Coile]

What happens when you use the formula you provided?

[RezaRaoofi]

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”)