A
Reaction score
0

Profile posts Latest activity Postings About

  • 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
    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
  • Loading…
  • Loading…
  • Loading…
Top Bottom