Divide the date into three fields year, Month, day

[alfakeah]

Hi friends,

I have in my schedule the date has already been entered
In another table I will add a reference field to get the date from the first table as in this formula:
[schedule].[date]

Required:
How do I get the date of the year in a separate field
And the date of the month in a separate field
Today's date is in a separate field

[abood89 · Accepted solution]

You can use split function with index 

split([date],"/")

https://support.google.com/appsheet/answer/10107984?hl=en

[SkrOYC]

Maybe this?

TEXT() - AppSheet Help

[abood89 · Accepted solution]

You can use split function with index 

split([date],"/")

https://support.google.com/appsheet/answer/10107984?hl=en

[alfakeah]

Thanks @abood89 @SkrOYC 

Thanks
split expression worked fine
He separated the date of the day, month and year
in this form
split([schedule].[date],"/")
It was shown in this form

Is there an addition to delete the day and month
And keep the year?

[abood89 · Accepted solution]

1.  Create a VC with name Split Text and expression split([schedule].[date],"/")
2. Create an other column with name year and expression INDEX([Split Text], 3) 

This will get you the third value of your date which is the year.

[alfakeah]

Very nice
It works fine

We don't need a VC   

to thank @abood89 

[abood89]

Glad it worked ☺️