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
> Date With Spaces Between Digits., Access 2010    
 
   
Alhakeem1977
post Jun 12 2018, 02:04 PM
Post#1



Posts: 103
Joined: 8-July 17



How can I achieve to convert date format with 2 spaces between the digits as the below:
From this format: 31-JUN-2018
To this format: 3 1 0 6 2 0 1 8

Thanks in advance.
Go to the top of the page
 
theDBguy
post Jun 12 2018, 02:13 PM
Post#2


Access Wiki and Forums Moderator
Posts: 73,276
Joined: 19-June 07
From: SunnySandyEggo


Have you tried?

CODE
Format(Day([DateField]),"0  0 ") & Format(Month([DateField])," 0  0 ") & Format(Year([DateField])," 0  0  0  0")

Hope it helps...
Go to the top of the page
 
Alhakeem1977
post Jun 12 2018, 08:06 PM
Post#3



Posts: 103
Joined: 8-July 17



thanks.gif
It works perfectly as I need it.

Thank you very much.
Go to the top of the page
 
theDBguy
post Jun 12 2018, 11:00 PM
Post#4


Access Wiki and Forums Moderator
Posts: 73,276
Joined: 19-June 07
From: SunnySandyEggo


Hi,

You're welcome. Good luck with your project.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    26th September 2018 - 08:13 AM