Re: How To Validate Date In SQR

[Mogullapalli Sridhar <msridh@SDTDEV.USWC.USWEST.COM>]

>
> Hi sridhar
>
> After accepting date in mm/dd/yyyy format, try the following if you are using
> oracle7
>
> begin-select
>
> to_date($date,'mm/dd/yyyy')
>
> from dual
>
> end-select
>
> and check for error status.... keep me posted
>
>
> shiv
>




Hi Shiv,

  Thanks for reply. Actually i am using Sybase SQR. When we run our report
the format comes like ...

********************************************************************************
SQR:  Structured Query Report Writer  VX.XXX
Copyright (C) XXXX-XX  SQ Software  All Rights Reserved

Enter end date (ccyymmdd):
********************************************************************************

Here we have to validate the date. Suppose if the user enter date like
19970230, then i have to inform that , it is not a validate date.

                                                  //\\\\
Reply immediately ...                            `| ~ ~ |'
                                                 (  O O  )
__________________________________________oOOo______( )_____oOOo________________

    .                                  Office Address  :
  .o8                                  M Sridhar
..o888oo  .ooooo.   .oooo.o             TCS, Unit 61/64,
  888   d88' `"Y8 d88(  "8             SEEPZ, Andheri (EAST),
  888   888       `"Y88b.              MUMBAI - 96,
  888 . 888   .o8 o.  )88b             PHone: 022 - 836 7162 Ext: 234/227/243
  "888" `Y8bod8P' 8""888P'             E-Mailid : msridh@sdtdev.uswc.uswest.com

                                                         Oooo
_______________________________________________oooO______(  )___________________
                                               (  )       ) /
                                                \ (      (_/
                                                 \_)