Date Parse time

[Anelisa_Bolosha1 (Anelisa Bolosha)]

Hi everyone I need some help with this:
It this error with this date on the database

But with this date :

It does show the error

[Shubham_Kinge]

Hello @Anelisa_Bolosha1
how you are parsing the string.
provide like.
var_datetime= DateTime.ParseExact(“2023-10-01”,“yyyy-MM-dd”,Globalization.CultureInfo.InvariantCulture)

[Anil_G (Anil Gorthi)]

@Anelisa_Bolosha1

Can you please show what expression are you using?

and to check the format open the datatable in locals panel and check what is the difference…

cheers

[Sudharsan_Ka]

HI @Anelisa_Bolosha1

Can you please share the expression you are using

May be you have multiple date formats , you can try with this one

DateTime.ParseExact(InputDate,{"yyyy-MM-dd","dd.MM.yyyy","MM/dd/yyyy hh:mm:ss","dd/MM/yyyy hh:mm:ss"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("Your Format")

Regards
Sudharsan

[Anelisa_Bolosha1 (Anelisa Bolosha)]

Hi @Shubham_Kinge , like so,

e

[Shubham_Kinge]

hello @Anelisa_Bolosha1
Not like that provide like,
DateTime.ParseExact(inceptiondate,“yyyy-MM-dd”,Globalization.CultureInfo.InvariantCulture).tostring(“dd/MM/yyyy”)

if input is in - then - only if / then /

[Sudharsan_Ka]

Try like this @Anelisa_Bolosha1

DateTime.ParseExact(InputDate,{"yyyy-MM-dd","dd.MM.yyyy","MM/dd/yyyy hh:mm:ss","dd/MM/yyyy hh:mm:ss","MM/dd/yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("Your Format")

Regards
Sudharsan

[Anelisa_Bolosha1 (Anelisa Bolosha)]

The input date is this:

‘commencementDate’ and it comes in this format: 2018-10-01, but I want to convert it to this format: dd/MM/YYYY

[Gokul001 (Gokul Balaji)]

Hi @Anelisa_Bolosha1

Have you tried with this expression

DateTime.ParseExact(inceptiondate,"yyyy-MM-dd",Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Regards
Gokul

[Sudharsan_Ka]

@Anelisa_Bolosha1

Try this

DateTime.ParseExact(inceptiondate,{"yyyy-MM-dd","dd.MM.yyyy","MM/dd/yyyy hh:mm:ss","dd/MM/yyyy hh:mm:ss","MM/dd/yyyy","dd/MM/yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd/MM/yyyy")

Regards
Sudharsan

[Yoichi]

Hi,

Simply can you try CDate as the following?

CDate(inceptiondate.Trim).ToString("dd/MM/YYYY")

Regards,

[Anelisa_Bolosha1 (Anelisa Bolosha)]

Thanks it worked fine now