How can I create a formula for Month and Day 1

[sk8er1]

I need to build a formula field for month and day ie..
1/19 ....what is the best way to do this...

Thanx

 

[lbass]

You need to provide the fields you have to work with, along with their datatype, and also an idea of how you want to use the formula, since that could be relevant.

-LB

 

[sk8er1]

I have a date field named ScheduleDate....I want to concatenate the month "/" and the day value.. ie 1/19

 

[lbass]

You don't need a formula. Right click on the datefield->format field->date/time-> and from the list, choose "3/1".

-LB

 

[sk8er1]

I right clicked on the field... but I did not see the format field->date/time list ....(I was looking on the field explorer)

Let me explain what I want to end up with. I need to concatenate a month and day (from a date field) to another field.... So I thought i needed to create a formula field out of the date field....

 

[lbass]

I meant for you to right click on the date field when it was on the report canvas. It would be helpful if you provided more information up front. Now that you've explained that you actually want to use the date field with another field in a formula, there is a different solution, but I still don't know what field you want to concatenate this with. Let's say it is a string field. Then use:

totext(month({table.date}),"0") + "/" + totext(day({table.date}),0,"") +" "+ {table.string}

-LB

 

[sk8er1]

Thanks for the response. Its been a while since I had to do something like this in Crystal...One last thing,
I am using Crystal with VS.NET, and I can't seem to find the field explorer. How can I get it back. Wierd stuff.

Thanks

 

[lbass]

I don't use CR.net, so can't guarantee that there IS a field explorer. Do you know that there was? Look for "formula field" or "field explorer" in the "Insert" menu.

-LB

 

[sk8er1]

Thanks alot. It works perfectly