Can u please try this step.My sample data
Change the data type from string to date
(optional step )
After changing you will see something like below
If this solution didn't work then please follow this approach
I have created a dummy Field which is a string ( you can use your string Field)
Now create a Calculated Field by taking your string value .
LEFT([Date Field], 4)
+ "-" +
MID([Date Field], 4, 5)
+ "-" +
RIGHT([Date Field], 2)
Now Drag this Field to your rows and u r good to go.
If this solves your issue and please mark the answer as correct and close the Thread.
This will help other members when they are searching for solutions to similar problems.
String to date_RP.twbx 1.0 MB
Thanks for the quick reply.....in the above example you have shown the dates are getting converted to the month of 'May' in the Date conversion (copy) field. What I need is something like this:
2015 / 01 === 01/01/2015
2015/02 === 01/02/2015
2015/03===01/03/2015 and so on where '01' would be the date , '02' would be the month and then the year(dd/mm/yyyy).
I tried your formula as well but still getting null.
Thanks and Regards,
1 of 2 people found this helpful
You can add day of the month part & then make Date.
If you want to add first day of the month for each record,
you can use the "datetunc" function.
datetrunc('month, [Newly created Datefield])
Thanks Rajeev for your assistance.