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

expressions
(Colin) #1

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) #2

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

(Grant Stead) #3

Not sure if it’s supported

(Steven Coile) #4

What happens when you use the formula you provided?

(Reza Raoofi) #5

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