[AccessD] Date Format Not Working

[Rocky Smolin]

Bill:

That generates a Type Mismatch error.  I think the Cdate doesn't like
'Friday, June 28, 2013  ' as an argument.

Rocky


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Saturday, June 27, 2015 9:48 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Date Format Not Working

Try format(cDate(Me.txtFromDate),"mm/dd/yy"). What I think is happening is
that format is not recognizing the argument as a genuine date, but rather as
text

On Sat, Jun 27, 2015 at 12:29 PM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> Dear List:
>
> I'm having a problem with a date conversion.
>
> I have two unbound text boxes holding a date range  - txtFromDate and 
> txtToDate.  They are formatted Long Date in the property sheet.
>
> When I need to filter the form to show only records in that date 
> range, I need to convert it to a short date bracketed by # and embed 
> in a SQL statement as part of the form filter.
>
> But whether I use Format(Me.txtFromDate,"Short Date") or
> format(Me.txtFromDate,"mm/dd/yy") the result is still the Long Date 
> format which the Me.Filter chokes on.
>
> Mysterious - I cannot figure out why  Format(Me.txtFromDate,"Short 
> Date") doesn't convert the date in the text box to mm/dd/yy format.
>
> MsgBox Format(Me.txtFromDate, "Short Date") still shows Tuesday June 
> 14,
> 2015 and it ends up that way in the Filter which don't work.
>
> txtToDate behavior is the same.
>
>
> Any clues?  What am I missing/doing wrong?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> <http://www.e-z-mrp.com/>
> Skype: rocky.smolin
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com