HTML Format

I am using below lone for Creating Data table in Text file from Excel file.
“”“+CurrentRow(“Site ID”).ToString+”“+CurrentRow(“EASI ID”).ToString+”“+CurrentRow(“Site Name”).ToString+”“+CurrentRow(“Site Type”).ToString+”“+CurrentRow(“CP/NCP”).ToString+”“+CurrentRow(“Operator”).ToString+”“+CurrentRow(“Structure Type”).ToString+”“+CurrentRow(“Power Modality”).ToString+”“+CurrentRow(“RFAI”).ToString+”“”

The output for last row “RFAI” column in Excel it is only Date but in data table it is showing with time

RFAI
04/30/2023 00:00:00
04/30/2023 00:00:00
04/30/2023 00:00:00

How can I show the date only in HTML table in email.

Hi @Nokib ,

Try keeping the preserve format true in the read range activity.

Regards,

HI,

Can you try to replace CurrentRow(“RFAI”).ToString with either of the following?

DateTime.Parse(CurrentRow("RFAI").ToString).ToString("MM/dd/yyyy")

OR

CurrentRow("RFAI").ToString.Split({" "c}).First()

Regards,