Your presentation was great! Unfortunately, you did not mention the Excel serial date format. Unfortunately, I can't find a way to convert the excel date format to a normal date. for example, 44553 converted to 12/23/2021 Could you explain this?
Hey Matt. Thank you for a great video! I am still having problems though, and wondered if anybody could tell me what I am doing wrong here: Case ( Evaluation copy end date < Current date) "No" Case ( Evaluation copy end date > Current date) "Yes" I can see if "Evaluation copy end date" has expired by looking at the date on the bottom right of my screen, but would really like a Yes / No output so that I can search all records with a Yes value in "Evaluation expired" If anybody can help, I would be really happy! Thanks. Sarah
Hey Matt! I am watching this video on my phone and can’t see the other comments, so I apologize if someone has already asked this. In your auto-enter calculation for enforcing a consistent date format, would GetAsDate(Self) work better than Date(Month(Self); Day(Self); Year(Self))?
Yes, you can use that method. However, it's a data coercion function instead of an explicit date function. It won't clean up the delimiters the user chooses. For example, it will leave either periods or dashes, if entered, and won't enforce a slash.
Your presentation was great! Unfortunately, you did not mention the Excel serial date format. Unfortunately, I can't find a way to convert the excel date format to a normal date. for example, 44553 converted to 12/23/2021
Could you explain this?
Hey Matt. Thank you for a great video! I am still having problems though, and wondered if anybody could tell me what I am doing wrong here:
Case ( Evaluation copy end date < Current date) "No"
Case ( Evaluation copy end date > Current date) "Yes"
I can see if "Evaluation copy end date" has expired by looking at the date on the bottom right of my screen, but would really like a Yes / No output so that I can search all records with a Yes value in "Evaluation expired"
If anybody can help, I would be really happy! Thanks. Sarah
Matt, would you please make a short video on fm context? without understanding it, it's hard to do a complex solutions
Yes, I'll look into doing a dedicated video about understanding context within FileMaker.
hay matt can i change date to another language??
Hey Matt! I am watching this video on my phone and can’t see the other comments, so I apologize if someone has already asked this. In your auto-enter calculation for enforcing a consistent date format, would GetAsDate(Self) work better than Date(Month(Self); Day(Self); Year(Self))?
Yes, you can use that method. However, it's a data coercion function instead of an explicit date function. It won't clean up the delimiters the user chooses. For example, it will leave either periods or dashes, if entered, and won't enforce a slash.
Thanks, Matt!