I think I'm missing something probably obvious, but I've been reading the help file for a while and I can't find a function I'm looking for (or a clever way to do it).
I have some data that I'm importing, and the date is expressed like this:
25 June 2018
2 February 1965
19 December 2012
I noted the DMY() function also expresses a format in this way, so for today's date if I issue DMY(DATE()) it would give 29 June 2018.
That's all fine, but I want to store the date into a date field, and it rejects the spelled out month.
I'm sure I could create a cross reference (Like "January = 1", "February = 2", but that seems cumbersome.
Is there some function that will manage a spelled-out date?
MIET, MASHRAE, CDCP, CDCS, CDCE, CTDC, CTIA, ATS
"Everything should be made as simple as possible, and no simpler."