Help formatting a date converted to text

[elsenorjose]

Hello all,

I need help formatting a date field that has been formatted to text to display in m/dd/yy format. It is being converted to text because I also have some If/Thens going on.

I'm using CR XI. Thank you!

Complete formula:

If {usrIMP_Planning.ReportProjectType} = 'labeling' And {usrIMP_Planning.QPRequired} = 'Yes'
Then (If {usrIMP_Planning.LabelingLoc} = 'GSI SD' Then ToText(Date(shiftdatetime({usrIMP_Planning.ProjEndDate},",0",",720")) + 7)
Else If {usrIMP_Planning.LabelingLoc} = 'GSI Cork' Then ToText(Date(shiftdatetime({usrIMP_Planning.ProjEndDate},",0",",720")) + 21))
Else 'N/A'

Section I need formatted:

...ToText(Date(shiftdatetime({usrIMP_Planning.ProjEndDate},",0",",720")) + 7)
...
...ToText(Date(shiftdatetime({usrIMP_Planning.ProjEndDate},",0",",720")) + 21))

 

[elsenorjose]

I found my own answer through a little more trial and error:

ToText(Date(shiftdatetime({usrIMP_Planning.ProjEndDate},",0",",720") + 7),"M/dd/yy")