brandie Posted June 21, 2007 Posted June 21, 2007 I know there is something totally obvious that I'm missing, but I just can't seem to figure this one out. I've got data that I've imported that shows a year as a 4 digit number (1983, 2004, etc). I need to get FileMaker to view that as a date. How can I use a calculation to say that DateField = January 1 (YearField) I've tried GetAsDate(YearField), but since FileMaker doesn't think it's a real date, that doesn't work.
brandie Posted June 21, 2007 Author Posted June 21, 2007 Ahhhh I was using that, but my silly silly mistake was that I was using a Date field type and doing an "AutoEnter" calculation, rather than making it a Calculation type field with results as a date. Ugh. Thanks for the help all.
Recommended Posts
This topic is 6426 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now