Divide the date into three fields year, Month, day

[anonymous]

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

[SkrOYC]

Maybe this?

TEXT() - AppSheet Help

[abood89]

You can use split function with index

split([date],“/”)

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

[anonymous]

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]

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.

[anonymous]

Very nice
It works fine

We don’t need a VC

to thank @abood89

[abood89]

Glad it worked