Well, it's a hack, but append a lead "0" to each element that needs it (month and day)
and then take the RIGHT two chars to construct the field
i.e.
month = June (6) - > "06"
month = Dec (12) - > "012"
Do a right on each to get "06" and "12"
That's why I hate Access. Just a pain in the ass for this stuff
>>>Use this to either construct a string
>
>Same problem as with month(): how can I format the string to "yyyymmdd"?
>
>If only I could say datepart('mm', moment), but it won't take it.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
