Please try below code and let me know .
IF ISNULL(STR(Date&Time Field Name)) Then " " END
thanks Amar. I dont have your source file hence can't open the workbook and show your work. can you upload here.
1 of 1 people found this helpful
This is Amar response!!
i am able to open the file.
IF ISNULL(STR([Date&Time])) THEN "" ELSE STR([Date&Time]) END
thanks, it worked!!