How to check that wheather field is date and also in dd/mm/yyyy format

• kuppurajm

  SSCommitted

  Points: 1593

  More actions

  June 2, 2011 at 10:17 pm

  #240780

  Hi,

  I have one table with the field of "Date1" of varchar type.

  I want to get all the records those are date and also in dd/mm/yyyy format.

  I am trying with following query.

  select ISDATE(Date1) from Table_1

  but it gives only the record which is in the formate of mm/dd/yyyy.but I want to check

  the field with dd/mm/yyyy.

• Latheesh NK

  SSCertifiable

  Points: 6559

  More actions

  June 2, 2011 at 10:37 pm

  #1333508

  Please Try this....

  Declare @STR varchar(10)

  Set @STR = '22/12/2010'

  Select IsDate(substring(@str,4,2) + '/' + substring(@str,1,2) + '/' + substring(@str,7,10) )

• sunilg 95099

  SSC-Addicted

  Points: 445

  More actions

  June 2, 2011 at 10:40 pm

  #1333509

  I am facing same problem in SSRS. Date is coming in dd/mm/yyyy string format from database and when i convert it to date is says "string is not date type" kind of error.

  NOTE: If date is coming in MM/dd/yyyy then it is only convertable into date format.

• kuppurajm

  SSCommitted

  Points: 1593

  More actions

  June 3, 2011 at 12:19 am

  #1333518

  Thank you very much.It's working fine.