IF field conditionned by time/date field

%3CLINGO-SUB%20id%3D%22lingo-sub-1997253%22%20slang%3D%22en-US%22%3EIF%20field%20conditionned%20by%20time%2Fdate%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1997253%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20lot%20of%20letter%20templates%20to%20use%20in%20official%20functions.%20All%20are%20in%20Luxembourgish%20language.%20We%20use%20a%20time%2Fdate%20field%20(not%20having%20the%20right%20date%20in%20those%20letters%20is%20embarassing).%3C%2FP%3E%3CP%3EFormat%20is%20%22L%C3%ABtzebuerg%2C%20den%20%3CDATE%3E%22%3C%2FDATE%3E%3C%2FP%3E%3CP%3EProblem%20is%20that%20in%20Luxembourgish%20language%20the%20article%20(%22den%22)%20becomes%20%22de%22%20when%20placed%20before%20certain%20sounds.%20I.g.%20you%20would%20write%20%22den%2013.%20Dezember%22%20but%20%22de%2014.%20Dezember%22.%3C%2FP%3E%3CP%3ESo%20I'd%20need%20an%20IF%20datefield%20starts%20with%204%20OR%205%20OR%206%20OR%207%20OR%2014.%20OR%2015%20OR%2016%20OR%2017%20OR%2024%20OR25%20OR%2026%20OR%2027%20%22de%22%20%22den%22%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%20Do%20Boolean%20operators%20work%20inside%20fields%3F%20Do%20I%20have%20to%20make%20a%20separate%20IF-Field%20for%20each%20number%3F%20Can%20I%20get%20help%20here%2C%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1997253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EWord%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

We have a lot of letter templates to use in official functions. All are in Luxembourgish language. We use a time/date field (not having the right date in those letters is embarassing).

Format is "Lëtzebuerg, den <date>"

Problem is that in Luxembourgish language the article ("den") becomes "de" when placed before certain sounds. I.g. you would write "den 13. Dezember" but "de 14. Dezember".

So I'd need an IF datefield starts with 4 OR 5 OR 6 OR 7 OR 14. OR 15 OR 16 OR 17 OR 24 OR25 OR 26 OR 27 "de" "den"

Is this possible? Do Boolean operators work inside fields? Do I have to make a separate IF-Field for each number? Can I get help here, please?

0 Replies