1) REPORT_ID UDATES
2) HQ\\SPL\2-16\07-08\Dated: 01/04/2007 01/04/2007
Srl No is field Headin
Srl No2 are the data
Data under the field Report_id is combination many fields including Date
What I want is to extract the DATE DATA AND CONVERT IT INTO DATE SO THAT I AM ABLE TO RETRIEVE DATE BETWEEN TWO DATES.
I MANAGED TO RETRIEVE THE DATE BY USING "DATE: Right([REPORT_ID],10)"
I EVEN USED -> CDATE(Right([REPORT_ID],10).
I TRIED FORMAT ALSO
BUT I AM GETTING ONLY STRING. CAN ANY ONE HELP ME IN THIS my id is akumar118@yahoo.co.in
2) HQ\\SPL\2-16\07-08\Dated: 01/04/2007 01/04/2007
Srl No is field Headin
Srl No2 are the data
Data under the field Report_id is combination many fields including Date
What I want is to extract the DATE DATA AND CONVERT IT INTO DATE SO THAT I AM ABLE TO RETRIEVE DATE BETWEEN TWO DATES.
I MANAGED TO RETRIEVE THE DATE BY USING "DATE: Right([REPORT_ID],10)"
I EVEN USED -> CDATE(Right([REPORT_ID],10).
I TRIED FORMAT ALSO
BUT I AM GETTING ONLY STRING. CAN ANY ONE HELP ME IN THIS my id is akumar118@yahoo.co.in