Good to see you already found a creative solution. Another solution could be the following:
A date consists of 10 charachters (2 days, 2 months, 4 years, and 2 dashes).
First create a calculation to Combine A with B to make your date convert to text (you can fill out nothing at B)
By using the function “Cut A from B for N charachters” you can “cut Date from 0 for 10 charachters”. That will result in just the date.
- This reply was modified 1 month ago by Eddie Heijblom.