PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Display BLANK charector When Date = 01-01-0001

View previous topic View next topic Go down

Display BLANK charector When Date = 01-01-0001

Post  maran on Mon Jul 27, 2009 7:24 pm

When date fiels value is 0001-01-01. I would like to display date field as b lank. How do we achive this?
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

MAPVAL

Post  razuk_r on Tue Aug 11, 2009 6:54 pm

Display BLANK charector When Date = 01-01-0001

A R RECORD
A DATFLD1 L DATFMT(*ISO)
A MAPVAL(('01-01-0001' *BLANK))

This will help to get the blank values if the data is 01-01-0001.
___________________________________
Regards,
Razuk.

razuk_r

Posts : 65
Join date : 2009-07-31
Location : Chennai

View user profile

Back to top Go down

Re: Display BLANK charector When Date = 01-01-0001

Post  maran on Sun Aug 16, 2009 12:01 pm

Razuk is correct
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

Re: Display BLANK charector When Date = 01-01-0001

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum