My Assistant
![]()
Custom Search
|
![]() ![]() |
![]() |
![]() Post#1 | |
![]() UtterAccess VIP Posts: 13,034 Joined: 6-June 05 From: Dunbar,Scotland ![]() | Hi Everyone I have the following field in a Query:- SD: DateSerial([years],[MonthID],1) Which produces the Date in the following Format:- 01/11/2018 How can I modify the DateSerial to produce the date in the following Format:- 11/01/2018 ?? Any help appreciated -------------------- Hope this helps? Mike Get happiness out of your work or you may never know what happiness is. |
![]() Post#2 | |
![]() UtterAccess VIP Posts: 10,908 Joined: 6-December 03 From: Telegraph Hill ![]() | Mike, Don't worry about how the date is stored (or how it is displayed in the table) - DateSerial gives you the correct date - just format in the display controls: "dd/mm/yyyy" hth, d -------------------- Regards, David Marten |
![]() Post#3 | |
![]() UtterAccess VIP Posts: 13,034 Joined: 6-June 05 From: Dunbar,Scotland ![]() | Hi David OK Many thanks ![]() -------------------- Hope this helps? Mike Get happiness out of your work or you may never know what happiness is. |
![]()
Custom Search
|
![]() | Search Top Lo-Fi | 22nd February 2019 - 09:15 AM |