How do you Search for a hyphen/dash in the date field.
[EDIT] – my real question should have asked “(em)dash not hyphen” – the dash is longer … ‘–’ vs ‘-’. My search did not produce expected results results but were not original expected to me original because I thought I was search the correct character / forgetting there was two different ones.
solved now – this was a user error (mine) due to the different between the two characters
contains instead of equals (same for bef to aft bet from until as well as hyphen emdash endash and other non-date character groups). The only hyphen dates that do not get automatically formatted to RootsMagic’s “hyphen-less” date formatting are illegal combinations such as 13-32-1001, 39 Septiembre, etc.
for invalid text dates run:
sorry I tried several variances contains / equal and with / without quotes – basically I am trying to find all dates that have hyphen. None produced results –
so for example I would want to find
Clearly either need something else to do in RM or I need to use SQL (which would be a very simple like%)
In your first post you used equals… unless that single character is the only character in a date field… fail is the correct result. Secondly, you searched equal “a hyphen” but your date field for Military Draft Registration is some form of dash (em or en)… NOT hyphen.
sorry I pasted wrong screen shot in original post – that caused confusion.
so my issue was the character – dash vs hyphen are not the same. The character I needed was ‘–’ nor -" (fairly subtle difference to notice). Now it works as expected.
Kevin
That Fact List invalid text dates always shows when I’ve done the same as you.
fro 1940 top 1950