How to convert this Date formate 26-Dec-2021 to this formate 26/12/2021

Help Activities
, ,
1

Suggest the Correct expresion to make a conversion

2

Hi @Gopi_Krishna1
try out this syntax

YourDateVariable.ToString(“dd/MM/yyyy”)

Thanks,
Robin

3

Hi @Gopi_Krishna1,

Just wrote a rough code on editor try this, will give you what you require I think
Datetime.parseexact(“26-Dec-2021”,“dd-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).tostring(“dd/MM/yyyy”)

Thanks,
Shikhar

4

I am getting this date as string formate…Can i able to convert it

5

Hey,
solution:
Datetime.ParseExact(strVar,“dd-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)
image

6

I am getting this date as string formate…Can i able to convert it

7

yes you can

8

String was not recognized as valide date time like this coming

9

OK, just show the error, also try printing in a message box and check if the date format is what you mentioned or it contains some trailing zero’s as well.

10

Screenshot 2022-01-17 142415
Screenshot 2022-01-17 142415861×427 15.2 KB

11

yes ,we can able to convert a date format by using string only

12

Try this :slight_smile:

Datetime.ParseExact(“26-Dec-2021”,“dd-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

13

Variable name date contains this 26-Dec_2021 value can I use this varible in this expression

14

as of my understanding Unformate is datetime variable right?

If it is so . double put double quotes
simply use
Unformate = 28-Dec-2021

15

Hey,
here is example - how to do it :slight_smile:
BlankProcess46.zip (2.2 KB)

16

Yes

Datetime.ParseExact(VariableHere,“dd-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

thanks,
Shikhar

17

Hi!

Try like this!

Date1

Regards,
NaNi

18

Thanks getting my expected Output

19

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