1,508 questions
In the query editor Property panel select the column and choose Long Date format.
--please don't forget to Accept as answer if the reply is helpful--
Access field date format?
VAer-4038
771
Reputation points
I have a field WorkDate in table WorkNote, and I would like to have the date format similar like this: Mon Jan-4-2021 No need to be exactly same, but including weekday information
Developer technologies Visual Basic for Applications
5 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2021-01-05T02:13:49.477+00:00 -
VAer-4038 771 Reputation points
2021-01-05T02:32:43.297+00:00 Thank you. Long date format is in table now, but not showing in query (when I double click query).
Sign in to comment -
-
Anonymous
2021-01-05T02:43:54.643+00:00 You may need to make the format change to the query field property (first screenshot).
--please don't forget to Accept as answer if the reply is helpful--
-
VAer-4038 771 Reputation points
2021-01-05T03:08:33.623+00:00 Oh, query property. But I right click WorkDate, nothing found for long date.
Sign in to comment -
-
Anonymous
2021-01-05T03:22:40.747+00:00 In the query panel try clicking the WorkDate column then check the property panel format
--please don't forget to Accept as answer if the reply is helpful--
-
VAer-4038 771 Reputation points
2021-01-05T04:05:34.667+00:00 Thank you. For WorkDate field, it does not come up a similar screenshot, but while I clicks other fields, it comes up the screenshot.
Not familiar with Access. Is it because it is column heading?
Sign in to comment -
-
Anonymous
2021-01-05T04:08:57.29+00:00 In your second screenshot click the dropdown in the Format box of Field properties
--please don't forget to Accept as answer if the reply is helpful--
-
VAer-4038 771 Reputation points
2021-01-05T04:25:28.847+00:00 Second screenshot is not for WorkDate.
-
Anonymous
2021-01-05T04:27:58.097+00:00 put the focus on the WorkDate column then click the dropdown in the Format box of Field properties
-
VAer-4038 771 Reputation points
2021-01-05T12:57:31.63+00:00 I was saying: For some reason, when I click WorkDate field, it shows Query Property, not showing field property. While I try to click other fields, it does show Field Property.
Here is the file link (I put some space inbetween, it seems forum does not accept the link): https://drive. google .com/ file/d/1RcVPqMNAXZ6HyN7Ly-3F2bqoOGhnbOtO/view?usp=sharing
Sign in to comment -
-
Anonymous
2021-01-05T14:24:18.313+00:00 Looks like the problem is its a crosstab query and the WorkDate is configured as a column heading
--please don't forget to Accept as answer if the reply is helpful--