Date format wrongly enter in excel

Help Studio
, ,
1

Hi Team,

Date format wrongly enter in excel like 12/09/2024 15:59:00 (my variable now.date.tostring)

but I need like 12/09/2024 15:59 PM

Anyone help please

thanks
shaik

2

Hi @shaik.muktharvalli1

Try this

formattedDate = Now.ToString("MM/dd/yyyy hh:mm tt")

Regards,

3 
DateTime.Now.ToString("dd/MM/yyyy hh:mm tt")
4

@shaik.muktharvalli1,

It could be format difference in Excel file.
Try using Format Cells activity to format the excel column in custom format MM/dd/yyyy hh:mm tt

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.