Converting Date and time formats

[Penganimation]

Hi,

May I know how to reformat this date format 7/20/2020 8:00:00 to 20-07-2020 08:00? thank you very much.

[Reddy_Paluri (Omkar Reddy)]

Hi @Penganimation,

Some useful link

DateTime Format In C#

Regards,
Omkar P

[Shubham_Akole]

Hi,
strvar="7/20/2020 8:00:00

use,
convert.ToDateTime(strvar).tostring("dd-mm-yyyy hh:mm)

[Srini84 (Srinivas Kadamati)]

@Penganimation

7/20/2020 8:00:00

@Penganimation

Check as below

Hope this helps

Thanks

[Penganimation]

thank you. Problem is i am reading these dates from a data table generated out of a excel sheet and it gives me an error when using this function mentioned in the link.

[Srini84 (Srinivas Kadamati)]

@Penganimation

Convert.toDateTime(row.item(“DATE”).ToString(“dd/MM/yyyy hh:mm”)

Try this and the assignment of variable should be string not a Integer

Check the type of the variable

Thanks

[Penganimation]

@Shubham_Akole

("dd-mm-yyyy hh:mm)

Thank you so much. Just to side track a bit, how to compare dates?

[Shubham_Akole]

current date??

[Penganimation]

Yes I want to check if the date I am using is later than the current date and time or not.

Basically I want to run something based on predefined dates all the way to the current date and stop

[Srini84 (Srinivas Kadamati)]

@Penganimation

Place a IF Condition

convert.ToDateTime(row(“DateColumn”)).ToString(“dd/MM/yyyy”) = now.ToString(“dd/MM/yyyy”)

Hope this helps

Thanks

[Shubham_Akole]

Hi,
used 1 string variable
strvar=system.DateTime.now.tostring("dd-mm-yyyy h:mm)

and Compare the both the string