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
> Default Date To 2019, Access 2007    
 
   
edin14166
post Dec 9 2018, 11:13 AM
Post#1



Posts: 394
Joined: 15-November 05
From: BiH


Hello,
I have date field where user enters date in format dd/mm/yyyy hh/nn and imput mask is set to 99,99,0000\ 00:00;0;_,
is there option to set default value for year in this long date to 2019 so the user would get someting like :
../../2019 ../.. ?
Thanks in advance...
Go to the top of the page
 
GroverParkGeorge
post Dec 9 2018, 11:30 AM
Post#2


UA Admin
Posts: 35,892
Joined: 20-June 02
From: Newcastle, WA


Try:

99/99/"2019 "99:00:00\ >LL;;_

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
edin14166
post Dec 9 2018, 11:42 AM
Post#3



Posts: 394
Joined: 15-November 05
From: BiH


Hi,
I am getting 12/12/2019 08:00 __ this last line is not needed ...
Go to the top of the page
 
edin14166
post Dec 9 2018, 11:49 AM
Post#4



Posts: 394
Joined: 15-November 05
From: BiH


Hello it worked like:
99/99/"2019 "00:00;0;_,

Thank You George...
This post has been edited by edin14166: Dec 9 2018, 12:01 PM
Go to the top of the page
 
GroverParkGeorge
post Dec 9 2018, 12:26 PM
Post#5


UA Admin
Posts: 35,892
Joined: 20-June 02
From: Newcastle, WA


Glad to hear you resolved the problem.

Continued success with the project.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th October 2019 - 06:50 PM