vendredi 17 janvier 2020

If Else Formula for Date field in Crysal Reports that keeps Date format - not string

So I have a formula in Crystal Reports to convert for a particular date. The formula is working, but converts the field to a string, and I need the field to be a date as I am exporting as a csv file and then loading data to a table. Is there a way to use this same logic but have the field remain as a date and not a string? Below is the current logic that I am using:

if  totext((Date(Year({Command.RENEWAL_DT}), Month({Command.RENEWAL_DT}), Day({Command.RENEWAL_DT}))),'dd/MM/yyyy') = "01/01/1800" then
   "01/31/2099" 
else 
   totext((Date(Year({Command.RENEWAL_DT}), Month({Command.RENEWAL_DT}), Day({Command.RENEWAL_DT}))),'MM/dd/yyyy')

Aucun commentaire:

Enregistrer un commentaire