Format ToText Date 1

[dianemarie]

Hello, I have a report with a default subtitle, but sometimes people like to put their own subtitle in, so I use a formula. It includes dates, which I have to make ToText to go along with the rest of the text. How do I format the dates in the formula so that they say March 2003 instead of the ugly database date with minutes and seconds etc. Here's my formula, any input would be greatly appreciated. I got frustrated trying to figure it out using Crystal Help. Thank you.

if {?Overwrite Subtitle} = '*'
then
totext({?@Begin_Date})+' through '+totext({?@End_Date})
else
{?Overwrite Subtitle}

 

[bdreed35]

Try this:

if {?Overwrite Subtitle} = '*' 
then 
totext({?@Begin_Date},"MMMM yyyy")+' through '+totext({?@End_Date},"MMMM yyyy")
else 
{?Overwrite Subtitle}

~Brian

 

[dianemarie]

Thanks so much Brian!