How to change the string date into specific date format

[vaibhav2.chavan (Vaibhav)]

How to change the string date into specific date format.

I want to change the string date e.g. from 26 Feb 2020 to 2020-02-24 (yyyy-MM-dd).

Can anyone please suggest the solution for this.

[NIVED_NAMBIAR (NIVED N)]

Hi @vaibhav2.chavan try this

date_1=“26 Feb 2020”

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

Try this way

Regards

Nived N

Happy Automation

[vaibhav2.chavan (Vaibhav)]

@NIVED_NAMBIAR

26 Feb 2020

@NIVED_NAMBIAR - Thanks for reply, but i’m getting the below error, can you please have a look on it.

[NIVED_NAMBIAR (NIVED N)]

Hi @vaibhav2.chavan it should be Culturalnfo instead of CulturalInfo

I had corrected in my first response.

Please check

How to change the string date into specific date format

Hi @vaibhav2.chavan try this date_1=“26 Feb 2020” date_2= DateTime.ParseExact(date_1, “dd MMM yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”) Try this way Regards Nived N Happy Automation

[vaibhav2.chavan (Vaibhav)]

@How to change the string date into specific date format

DateTime.ParseExact(date_1, “dd MMM yyyy”,System.Globalization.CulturaInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

@NIVED_NAMBIAR - Still getting same error.

[ppr (Peter Preuss)]

Culturelnfo instead of CulturalInfo

[NIVED_NAMBIAR (NIVED N)]

Thanks @ppr for correction.
Sorry @vaibhav2.chavan for mistake

[vaibhav2.chavan (Vaibhav)]

@ppr

CulturalInfo

@NIVED_NAMBIAR/@ppr - I’m still getting the same error after correction. Please help.

[ppr (Peter Preuss)]

sometimes it hangs in the cache:

• take the entire statement into Clippboard (CTRL+C) and delete it
• close expression editor
• open expression editor and paste it back (CTRL+V)
• close expression editor

or just do the same within a second assign and if its working delete first assign.

also take a note on:
import namespace:

and change the part to: System.Globalization. CultureInfo.InvariantCulture

[NIVED_NAMBIAR (NIVED N)]

Please check this one for correction of error

BC30456: CultureInfo is not a member of Globalization

[vaibhav2.chavan (Vaibhav)]

@How to change the string date into specific date format

DateTime.ParseExact(date_1, “dd MMM yyyy”,System.Globalization.CulturaInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

@NIVED_NAMBIAR/@ppr -

After adding system.Globalization still getting same error.

[ppr (Peter Preuss)]

Please correct the typo:

As mentioned above. After adding System.Globalization to the namespace imports you can go with the shortened name: CultureInfo.InvariantCulture

[NIVED_NAMBIAR (NIVED N)]

Hi @vaibhav2.chavan it should be

System.Globalization.CultureInfo.InvariantCulture

[111658 (章 宇豪)]

WINDOWS系统可以设置日期时间的表示格式，从/形式改为-形式