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: 102
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.

--------------------
Best Regards,

Al Hakeem1977
Go to the top of the page
 
theDBguy
post Jun 12 2018, 02:13 PM
Post#2


Access Wiki and Forums Moderator
Posts: 72,423
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...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Alhakeem1977
post Jun 12 2018, 08:06 PM
Post#3



Posts: 102
Joined: 8-July 17



thanks.gif
It works perfectly as I need it.

Thank you very much.

--------------------
Best Regards,

Al Hakeem1977
Go to the top of the page
 
theDBguy
post Jun 12 2018, 11:00 PM
Post#4


Access Wiki and Forums Moderator
Posts: 72,423
Joined: 19-June 07
From: SunnySandyEggo


Hi,

You're welcome. Good luck with your project.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    21st June 2018 - 09:05 AM