473,473 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Passing Date format on part of a control

Brilstern
208 New Member
Q: How do i use a date format on part of a control.

I have a control
Expand|Select|Wrap|Line Numbers
  1. =[EAS] & "    Section: " & [Instrument]
I want to pass a format on the EAS field to be YYYYMMDD.

This is what I have used previosly but within a single control. How do i use this format on the EAS part of the control.
Expand|Select|Wrap|Line Numbers
  1. =Format(Date(),"YYYYMMDD")
I have looked but nothing refers to only part of the control.

Sgt B
Jan 30 '12 #1
3 1307
Rabbit
12,516 Recognized Expert Moderator MVP
I'm not quite sure what you mean. I think you mean that you want to format EAS, which is a date.
Expand|Select|Wrap|Line Numbers
  1. =Format([EAS],"YYYYMMDD") & "    Section: " & [Instrument]
Jan 30 '12 #2
Brilstern
208 New Member
I didn't try it with just the Format() without Date(). But this makes since. I will try it when I get to work in the morning. Thx

Sgt B
Jan 30 '12 #3
NeoPa
32,556 Recognized Expert Moderator MVP
Assuming your [EAS] field is a Date format field (which is implied by your question) then Rabbit's solution is what you want (Single quotes (') may be advised as it's handled by Jet - but that's being pretty picky and the double quotes will work fine in Access).
Jan 30 '12 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: mirza i | last post by:
in asp i have this line: ..... Set paramsx = cmdUpdatex.CreateParameter ("@invdate", addate, adParamInput, 50, invdate) cmdUpdatex.Parameters.Append paramsx ... (the invdate value is a...
1
by: Laurence Neville | last post by:
This is regarding a change in the Short Date format under Hebrew Regional Settings, that has caused huge problems in our ASP web application. The change appears to have been introduced sometime...
2
by: Ian | last post by:
I would like to have some validation on a date field. The date format is dd/mm which is used for our financial year end. I suppose I need also consider leap years. Please can you shed some light on...
3
by: VivN | last post by:
I have an unbound form (Access 2000 ADP front end/SQL server backend) to collect parameters, one of which is a date. The date is being reordered to mm/dd/yyyy if it involves any day up to 12th of...
5
by: Ishaan | last post by:
Hi, Is there any way to pick the data format from operating system settings using C#? I am doing an ASP.Net Application. -- Software engineer Petroleum Development Oman
1
by: Rich | last post by:
Hello, I have some datefields in a dataset (ds1). I bind some textbox controls on a windows form to these date fields in ds1, but I only want to see 01/01/2004 instead of 1/1/2004 8:00:00 AM. ...
1
by: Anatoly Kurilin | last post by:
Hi, I need to enter date into a control without a month day - just mm/yyyy. I tried to use format mm/yyyy. It displays date OK, but when I edit, it shows dd/mm/yyyy. What's the corret way o doing...
1
by: scott | last post by:
Hi Everyone, I don't know if this is the correct forum but I thought i'd ask. I have an access DB with a function to automatically safe a table with fields i'm mail merging into MS Word. Word...
9
by: insomniux | last post by:
Hi, I am having a problem with formatting the default value of a date field. It has been discussed earlier in many topics, but still I cannot solve the problem. What's happening: I have various...
10
by: ARC | last post by:
Hello all, General question for back-end database that has numerous date fields where the database will be used in regions that put the month first, and regions that do not. Should I save a...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.