How to convert string datatype to datetime datatype

Help Studio
, ,
1

Hi,
I have an assign activity Receiveddate=6-jun-23, Receiveddate is of string datatype.
In Sql query datatype is datetime.
In the Activity Execute Non Query, while providing Insert query there in parameters I provided datatype as string .
So can any one please explain how can I change the ‘string’ datatype to ‘datetime’ datatype,
Datatype I cant change in the sql because it is refelecting for other cases also.

2

Hi @Chippy_Kolot

Try this

DateTime.ParseExact(yourString, "yyyy-MM-dd", CultureInfo.InvariantCulture)

3

Hi,

Thanks

4

Hi @Chippy_Kolot

Try this:
DateTime.ParseExact(“16-jun-23”,“d-MMM-yy”,System.Globalization.CultureInfo.InvariantCulture)

Hope it helps.

5

@Chippy_Kolot

Try this

DateTime.Parse(InputString)

image

I hope it helps!!

6

@Chippy_Kolot

If you find the solution for your issue. Please, mark as solution to close the loop.

Regards,