Date conversion problem

Help Studio
, ,
1

i want to to convert 29-JAN-2021 to a date format. how can i do this?
input-29-JAN-2021
Output-29.01.2021

1 Like
2

Hi @arijit1213

Check this code

date_1 = DateTime.ParseExact(“29-JAN-2021”,“dd-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

1 Like
3

Hi @arijit1213,

you can also try this, CDate(“29-JAN-2021”).ToString(“dd.MM.yyyy”)

Cheers
Happy Learning

1 Like
4

@arijit1213

Check the below video for your reference

Hope this helps you

Thanks

5

hi @NIVED_NAMBIAR
my input-27.12.2020
(string format)
i want this as date format.
output-27.12.2020
(date format)
how can i do this?

6

Hi @arijit1213

Use the assign activitiy as below

output_1= DateTime.ParseExact(input_date,“dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture)

Where output_1 is date format and input_date is string format

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

7

@NIVED_NAMBIAR

image
image1920×1080 255 KB

i want 27.12.2020 as a output but i got 12/27/2020

8

Hi @arijit1213

Since u are calling as string specify the format u need infinal like this

date_var.ToString(“dd.MM.yyyy”) where date_var is date variable.

Regards
Nived N
Happy Automation

9

hi @NIVED_NAMBIAR
if i do this then my final data will be a string but i want my output data as a date format.