Hello Everyone! We have a Tempo Report with 2 different flavors of Ex

@preetamb Hopefully I am correctly understanding your circumstances here, but it seems like this is a problem that can be solved using the available infrastructure of your smart service (or possibly link for that matter).
In the smart service when you configure your inputs for fields to export, in the Value section rather than simply putting the CDT field, you can write an expression that will manipulate the data in the field, something to the effect of, rule!APP_convertDateFormat([yourdata]). That way what gets exported to excel will be the date in the format you want. In the event that the data that ends up in the spreadsheet is still in the wrong format, see whether that is simply from a date-formatting default setting of Excel.
Conversely, depending on what options you have for passing data using the export link, you could instead modify the data that you pass to the export link using a rule you have created for that purpose (again something like rule!APP_convertDateFormat([yourdata])). If the link doesn't have that functionality, you could also simply alter the format in which your data is displayed on the report (again using a simple rule) so that when it exports it is already in the correct format.
I hope this helps. Just let me know if you would like any further explanation on anything I've said.

@preetamb Hopefully I am correctly understanding your circumstances here, but it seems like this is a problem that can be solved using the available infrastructure of your smart service (or possibly link for that matter).
In the smart service when you configure your inputs for fields to export, in the Value section rather than simply putting the CDT field, you can write an expression that will manipulate the data in the field, something to the effect of, rule!APP_convertDateFormat([yourdata]). That way what gets exported to excel will be the date in the format you want. In the event that the data that ends up in the spreadsheet is still in the wrong format, see whether that is simply from a date-formatting default setting of Excel.
Conversely, depending on what options you have for passing data using the export link, you could instead modify the data that you pass to the export link using a rule you have created for that purpose (again something like rule!APP_convertDateFormat([yourdata])). If the link doesn't have that functionality, you could also simply alter the format in which your data is displayed on the report (again using a simple rule) so that when it exports it is already in the correct format.
I hope this helps. Just let me know if you would like any further explanation on anything I've said.