Dateparse should be able to get you what you need, as you can specify the format of the date&time, for example:
DATEPARSE('yyyyddMMhhmmss', [Date String Field] )
Hope this helps!
2 of 2 people found this helpful
I have taken a sample data as per your requirement
Create a calculation like below to convert your string to date
Date diff calculation to find the seconds between you can replace seconds with hours or minutes as per your wish
Hope this helps kindly mark this answer as correct r helpful so that it will help others
Hey thanks a lot Naveen,I was having problems with Dateparse since it was not supported to my database connection.But I got them to extract the database to my local machine which made my life a lot easier.