Good afternoon. I have added a new column to an already existing view in a database. The field selection for the column is pulling the date straight from the Keywords view, and the date is in this format(Feburary 6, 2008). Is there a formula that can be written to change the date format to show as 02/06/2008.
Thank you
Subject: Modify Date Field In Column
I’m not sure what you mean with “Keywords view” in a column formula, but for formatting the display check the column properties. There is a tab that allows you to switch from general formatting to e.g. Date formatting and configure display options as you need them.
This might not make sense, however, if the date is not really a date, but a string.
Subject: RE: Modify Date Field In Column
Sorry for the confusion, there is already a view in database called “Keywords” that this date field is coming from. Which means the date is already entered in the database in a field as (Feburary 6, 2008). Meaning that when I added the new column and selected the date field the format is of the date is already set. But I don’t want it to display like that in the column. I did go into column properties to try and change the date there, but it didn’t have what I needed.
Subject: RE: Modify Date Field In Column
Unfortunately, keyword fields are always of type text. Even if the dates in the config documents should be real date fields, what is stored in the documents you display in the view is no longer a date. Notes is not relational, the info is really copied into the documents.
You can use @Date or @ToTime to convert either numbers or a string containing a date into a real date, that could be formated to your likings (either using the column property or using @Text), but I doubt, that “Feburary 6, 2008” is a valid input for @ToTime. If you can be sure, that the format is always the same, you could use more string operations to retrieve the moth, day and year component first, but this is a little tedious.
Subject: RE: Modify Date Field In Column
I was able to use the @Texttotime formula, and this fixed the date as I needed. Thank you for your assistance
Subject: RE: Modify Date Field In Column
Glad it worked even better than I had hoped for.
Note, that @ToTime is probably the preferred choice (if you don’t have and R5 or older clients over @TextToTime, as it is more robust. @TextToTime will throw an error if the argument is a date already, while @ToTime will not (although Designer help says otherwise, probably just copy/pasted over from @TextToTime).