I do think I remember someone saying Date isn't a true date, it's more like a string or something, so it should work with formula(text)