How to Convert any format Date(String Variable) into YYYYMMDD format

Help Studio
1

Hello,
I am trying to convert the date which comes in String format into standard YYYYMMDD format. Can anyone please help.
Actually I am not sure in which format Business team will update the data in Input file, Hence whatever will be the format that string needs to be convert as YYYYMMDD.

Most common received format:
dd-mm-yy (e.g.: 25-Apr-22)
MM/DD/YYYY(e.g.: 4/25/2022)
YYYY-MM-DD(e.g.: 2022-04-27)
yyyymmdd (e.g.: 20220421)
DD.MM.YYYY (e.g.: 21.02.2022)

Some other rare formats:
YYYY MM DD (e.g.: 2022 09 01)
DD/MM/YYYY (DD M YYYY) - eg: 16/03/2022 (16 March 2022)

1 Like
2

Hey @nilesh.mahajan

What is your timezone your using please ?

Thanks
#nK

3

@nilesh.mahajan

Check below thread for your reference

Hope this will help you

Thanks

4

Is there a standarization possible here? Like Bussiness team need to follow one particular date format. Are these datas generating manually or through some tool?

5

India Standard Time

6

No, Business team is not ready to make it standard, client is God for them… :grinning:

7

Hey @nilesh.mahajan

You need to do DateTime.Parse function by passing date string and IST culture format.

Please try and let us know

Thanks
#nK

8

Hello @nilesh.mahajan ,

:grinning: DateTime.parse can work but you will have to dynamically provide the format.

9

working with dateTime.ParseExact method and using an array with the different formats can be checked: