I've searched for the solution to this but just cannot figure it out!!!

 

I have a date/time field in an SQL database that I need to do the following with......

 

Check if it is blank/null and if it is output a string ie "No Date Set" and if not then output the date after doing some work on it.

 

the date is in dd/mm/yyyy HH:MM:SS format

 

My problem is that I am fairly new to Crystal and cannot figure out how to convert a date to a string so that the txt can be allocated?

 

Hope this makes sense to someone....lol

Much appreciated