How to convert yyyy-MM-dd format into dd/MM/yyyy using Dataflow

Question

I have tried like as below but stated format not accepted

I have below format as of now

{"ValidFrom":"2021-01-01 00:00:00","ValidTo":"2022-01-31 00:00:00"}
,{"ValidFrom":"2022-01-01 00:00:00","ValidTo":"2023-01-31 00:00:00"}

Required {"validFrom": "01/01/2021", "validTo": "31/01/2022"}

Answer 1

Hello @Abhijit Bhadra ,

Thanks for the question and using MS Q&A platform.

You will have to use a combination of toString and toDate functions in your expression builder to first covert your source column string type into date type and then format as needed using toString as shown in below sample:

**For example**: toString(toDate(DoB, 'dd-MM-yyyy'), 'dd/MM/yyyy')   

The above sample expression will result the below format:

**Another example**: toString(toDate('2021-01-01 00:00:00', 'dd-MM-yyyy'), 'dd/MM/yyyy')   

The above sample expression will result the below format:

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators