?
Solved

how to convert text to a date?  1/1/2009 to January 1, 2009

Posted on 2010-03-31
2
Medium Priority
?
251 Views
Last Modified: 2012-06-22
how to convert text to a date?  1/1/2009 to January 1, 2009  I can convert to text and return 01/01/2009

Thank you!
0
Comment
Question by:kgittinger
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 29191231
totext(cdate({datefield}), "MMMM d, yyyy")
0
 

Author Closing Comment

by:kgittinger
ID: 31709340
Great, Thanks!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…

600 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