Formating dates.

[basuramandan]

First let me say I am a newbie...I normally take reports that others have written and adjust them to work for me. I have run into something that I cannot figure out (which is not all that shocking)

I am on an old Crystal 7 and I have the formula below. I need it to force it to display MM/DD/YYYY. I cannot figure out how to make it work.


ToText(ExercisableDate( {optstmt_view.NUF_Grant_Number}, {optstmt_view.NUF_Grant_Optionee_Number}, {optstmt_view.Grant_Date}, {optstmt_view.Grant_Expiration_Date}, {optstmt_view.Granted}, {optstmt_view.NUF_Exercisable_Flag}, {optstmt_view.NUF_Grant_Vesting_Number}, {optstmt_view.NUF_Vesting_Method}, {optstmt_view.Vest_From_Date}, {optstmt_view.NUF_Grant_Termination_Date}, {optstmt_view.NUF_Term_Continue_Vest_Flag}, {optstmt_view.NUF_SAR_Type_If_Allowed}, 1,));


Thank you in advance..

Dan

 

[fisheromacse]

What does your raw data look like?

What do you want the formula to return? (mm/dd/yyyy, correct?)

What does the current formula return?

Do you need it to be a date (ie: date sortable) or text that looks like a date?

 

[basuramandan]

It currently display's as m/d/yyyy (unless there are 2 digit month and day) I want to force the 2 digit month and day.

I believe text that looks like a date should be fine.

 

[Turkbear]

Hi
Is

ExercisableDate()

a custom function you have added to CR's functions?
It is usually an XML thing...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[basuramandan]

This is where I get in trouble. I am not sure if it is a custom function. How would one figure that out?

 

[Turkbear]

Hi,
Look in the function list in the record selection editor and see if it is listed under Additional Functions ( I am pretty sure that it is a custom add-on, since I can find no mention of it in CR docs...)

If so, you will probably need to find the docs for its usage in order to change its formatting behavior..







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[basuramandan]

It is a custom function. I am going to have to dig and see if there are an docs on the custom function.

Thank you.

 

[lbass]

Did you try the following?

ToText(ExercisableDate( {optstmt_view.NUF_Grant_Number}, {optstmt_view.NUF_Grant_Optionee_Number}, {optstmt_view.Grant_Date}, {optstmt_view.Grant_Expiration_Date}, {optstmt_view.Granted}, {optstmt_view.NUF_Exercisable_Flag}, {optstmt_view.NUF_Grant_Vesting_Number}, {optstmt_view.NUF_Vesting_Method}, {optstmt_view.Vest_From_Date}, {optstmt_view.NUF_Grant_Termination_Date}, {optstmt_view.NUF_Term_Continue_Vest_Flag}, {optstmt_view.NUF_SAR_Type_If_Allowed}, 1),"MM/dd/yyyy");

Not sure that comma after the 1 in your original post belongs there, so I took it out.

-LB

 

[basuramandan]

lbass,

Thank you very much..that worked..you are awesome.

Dan