I've been reading a lot about dates and date formats. I believe at this time date formatting does not work in FMT. So, I am trying to create a work around to a problem I am having. I have a relationship built on the Year of a birthDate. Of course, simply getting
Year ( Birthdate )
does not work in FMT because it does not support the Year function. OK, I can deal with that by forcing Year to be dealt with as a string by using
Left ( Birthdate ; 4 )
. This works in FM but does not work in FMT as FMT's default for dates is YYYY/MM/DD instead of FM's default of MM/DD/YYYY (this could be a localized issue. I'm in the US.)
I have to come up with a solution that works both in FM and FMT. I thought I might be able to use an IF statement to figure out which function to use, Year or Left depending on if it is FM or FMT. I just can't seem to figure out a solution. Suggestions?