synapsevampire....

[QueSpr04]

Thanks for that formula, it worked great. However I am new to the programming field, fresh out of school in the real world of programming so please bear with me But,within this formula, I need the date format to be "Saturday, May 1, 2004" in which the program displays it as 5/1/04. I tried to go to format field and change the format there, but it thinks it is a string instead of a date field. How can I change the format within the formula? Thanks!

 

[hilfy]

I'm not synapsevampire, but I think I've may have your answer. Use this format string in the ToText part of your formula:

'dddd, MMMM d, yyyy'

(instead of 'M/d/yy')
If you go to the Help and search for the ToText formula, there are links that will take you to places where you can determine the valid formats for various types of data, including dates.

-Dell

 

[synapsevampire]

I responded to your orignal thread with this same solution.

This website is soooo flakey now that it may have been lost...

Cold Fusion and a heavily trafficked technical support site, there's a nightmare in the making

-k

 

[QueSpr04]

Those are my thoughts exactly Synapesvasmpire! Thanks! What i tried was the formula:
If minimum({cr_citations.e_date}) = maximum({cr_citations.e_date}) then ({cr_citations.e_date})
else
dateserial(year({cr_citations.e_date}),month({cr_citations.e_date}),1)

Will this formula display the date for one day versus the entire month?

 

[synapsevampire]

I answer too many posts to recall the specifics of your original post. Note that if you're starting a new thread based on an old thread, copy and paste the thread767-902127 (this posts thread) under the post title as a reference.

Neither will display dates for the entire month, and since your basing the display on the fields and not a parameter, you will only get the minimum and maximum for the data in the tables, not parameters used.

I would also suggest that you title your post to specific people here, there are lots of extremely qualified people here and they may not respond to you as a result.

A formula such as the following will display either the same day (once) or both dates for a date range parameter :

If minimum({?dateparm}) = maximum({cr_citations.e_date}) then
totext({?dateparm}),"dddd, MMMM d, yyyy")
else
totext(minimum({?dateparm})),"dddd, MMMM d, yyyy")&" to "&
totext(maximum({?dateparm})),"dddd, MMMM d, yyyy")

-k