Converting a stored value to a simple date

App Building
1

When I save a date in YYYY-MM-DD format to LocalStorage is takes on the format as shown in the attachments. I would like to display this without the time stamp.

I have tried the substring function as:
substring({{ localStorage.values.mBillDate }},1,10)

I have tried the convert function. I always end up with the time stamp.

How do I get rid of the time stamp?

Mike

pict1
pict11599×676 167 KB

pict2

2

I have solved this.
The answer is to create a text field and copy the date to the text field. Like what I have shown below:
UPDATE Invoices02 SET BDREMARK = CONVERT(DATE1, CHAR);
This will just the date component in the BDREMARK field with no time stamp.
Mike

1 Like
3