UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Dateserial, Access 2016    
 
   
mike60smart
post Feb 12 2019, 07:15 AM
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.

Go to the top of the page
 
cheekybuddha
post Feb 12 2019, 07:19 AM
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
Go to the top of the page
 
mike60smart
post Feb 12 2019, 12:53 PM
Post#3


UtterAccess VIP
Posts: 13,034
Joined: 6-June 05
From: Dunbar,Scotland


Hi David

OK Many thanks

cheers.gif

--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
« Next Oldest· Access Q and A· Next Newest »
 
Display Mode: Standard · Switch to: · Switch to: Outline

Track this topic ·Email this topic · Print this topic · Subscribe to this forum

Custom Search


RSSSearch   Top   Lo-Fi    22nd February 2019 - 09:15 AM