RE: [sqr-users] New hire

[Bob Stone <bstone@fastenal.com>]

is that date input coming from a file or a database table?  because if it's
coming from the database table you can use date masks to bring it
in...otherwise, you can turn it into the correct date format on the insert.

For example you can grab the 'DD-MON-YY' from the table, and make it a
DD-MON-YYYY in the string:
begin-select
to_char(a_date_DD_MON_YY, 'DD-MON-YYYY')  &my_date
  let $my_date = &my_date
from table
where [$clause]
end-select

Or if it's an input from a file and you're trying to put it into the table
you can put it in whatever format you need, and read it from the table like
above:

unstring $input by $sepchar
         $my_date

BEGIN-SQL
insert into table ( a_date_DD_MON_YY ) 
values ( to_date($my_date , 'DD-MON-YY') )
END-SQL

If your SQR report doesn't make use of that date in any database tables,
well that sorta confuses me, but maybe setting up a date variable and using
the SQR edit masks would do it for you too.


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Meena Kandasamy
Sent: Tuesday, April 19, 2005 6:26 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] New hire


Hi Everybody,

I am designing a new hire report that will allow date mask of DD-MON-YYYY.

I am validating the input with format='DD-MON-YYYY'

But the publisher and program accepts the date value as DD-MON-YY.

One of my collegues says its possible to do such format.

She says we have to use type=date format.

Any ideas?


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users