Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Format text box, mmm ddd yyyy

Posted on 2011-03-12
13
502 Views
Last Modified: 2012-05-11
Experts,

How do I format this:
=[Forms]![frmDateRange_Weekly].[txtdatefrom] & " - " & [Forms]![frmDateRange_Weekly].[txtDateTo]

as mmm dd yyyy

thanks
0
Comment
Question by:pdvsa
  • 6
  • 4
  • 3
13 Comments
 
LVL 75
ID: 35117289
How about ...

=Format([Forms]![frmDateRange_Weekly].[txtdatefrom],"mmm dd yyyy") & " - " & Format([Forms]![frmDateRange_Weekly].[txtDateTo],"mmm dd yyyy")

mx
0
 

Author Comment

by:pdvsa
ID: 35117558
Mx:  I had to change the order of the ddd mmm but I dont seem to get the dates from the frmDateRange.  There are no mispellings.  

=Format([Forms]![frmDateRange].[txtdatefrom],"ddd mm yyyy") & " - " & Format([Forms]![frmDateRange].[txtDateTo],"ddd mm yyyy")

IN the attached screen print.   The one on the right is without any formatting.  The one on the left is with the formatting.  But you can see the dates are not correct between the two.  The one on the right is referencing the correct dates.  
untitled.JPG
0
 

Author Comment

by:pdvsa
ID: 35117565
Do you see anything wrong with the formatting of the above?  The only reason why the dates are different is because of the formatting on the left one.  
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 75
ID: 35117578
I see nothing wrong.  It simply looks as if the same date was put into txtDateFrom and txtDateTo ... ?
It is certainly working correctly in the Formatting sense.

mx
0
 

Author Comment

by:pdvsa
ID: 35117717
but this is not the case.  I copied and pasted that textbox.  The ONLY difference is the formatting.  

left one:
=Format([Forms]![frmDateRange].[txtdatefrom],"ddd mm yyyy") & " - " & Format([Forms]![frmDateRange].[txtDateTo],"ddd mm yyyy")

right one:
=[Forms]![frmDateRange].[txtdatefrom] & " - " & [Forms]![frmDateRange].[txtDateTo]


Do you see any issue here?  Maybe I am missing something.  I also tried single and double quotes.
0
 
LVL 75
ID: 35117785
Looks to me they are exactly the same (other than Format) ... beyond weird.


Capture1.gif
0
 

Author Comment

by:pdvsa
ID: 35117896
well fiddle sticks.  that is weird.  At least I am not crazy because I did the same thing you did to format it before I posted the question and did not work right.  Must be an answer to this.  Maybe corruption or something but I have compacted repaired and  compiled.  Oh well it will sort itself out.  Maybe I did something screwy somewhere.  
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 35118001
Nothing wrong with the formats, but you have to make up your mind.
If you wish the day and not the month use this format:

"dddd dd yyyy"

/gustav
0
 

Author Comment

by:pdvsa
ID: 35118601
Ok.   Will test this when @ cmptr.  Thx
0
 
LVL 75
ID: 35118609
But how does that explain that the date is the same for the example that is Formatted ?

mx
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 35120158
You omit the day, only displaying the weekday and month and year.
As the example dates are one week apart, they then look the same.

/gustav
0
 

Author Closing Comment

by:pdvsa
ID: 35122740
Gustav, it worked.  

the following did not even work for dates that were far apart and I dont completely understand why:
=Format([Forms]![frmDateRange].[txtdatefrom],"ddd mm yyyy") & " - " & Format([Forms]![frmDateRange].[txtDateTo],"ddd mm yyyy")

I believe you mentioned to use "dddd dd yyyy" for when dates are close together.  I have never heard of using that format order.  It is not logical.  Oh well at least I have what works.  Thank you.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 35122911
Well, the idea is that you can format a date to nearly whatever string expression you may wish.

/gustav
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question