Hi All,

I am having below requirement.

In one of my table,one of my column is having date format like 'May 30, 2013'.

I need to add 6 months to this date after that i need to append the string to this column. I am trying like below.

COMPUTE FREQUENCYDATA2/MDtrYY =DATEADD('May 30, 2013', 'M', -6);

After this how to append the String to "FREQUENCYDATA2" variable?

Can anyone help me out of this.

Thanks in advance.

This message has been edited. Last edited by: santu,

In this case you need a book...

There is so much to do about dates that you should buy "almost 1001 ... Titlebook

It is worth the price

Thankyou for your suggestion.

I will go through that book but i dont have enough time to read the book.

Can you please provide me some code to append the data to date value?

Santu,

Please try out the search function above to help you out.

As you are new to WebFOCUS it is likely that most of the questions you have may well have been asked before - and will have been answered also.

Also check out your local branch to see what training is available to you.

T

You can use the DATETRAN function to convert the date to a string and then use concatenation to append the text that you want to it.

REF_S10/A22 = DATETRAN(FREQUENCYDATA2,'(MDYY)','(tr)' ,'EN',22,REF_S10);

will produce a string representation of your computed date - concatenate to it as needed.

This message has been edited. Last edited by: John W Price,

You can also use the FPRINT function, much easier than the DATETRAN function:

DEFINE FILE CAR
MYDATE/YYMD WITH COUNTRY = '&YYMD';
END

TABLE FILE CAR
PRINT
COMPUTE DT1/A10 = FPRINT(MYDATE,'YYMD', 'A10');
COMPUTE DT3/A10 = FPRINT(MYDATE,'D.M.YY', 'A10');
COMPUTE DT4/A10 = FPRINT(MYDATE,'M-D-YY', 'A10');

COMPUTE DT5/A20 = FPRINT(MYDATE,'DMtYY', 'A20');
COMPUTE DT2/A20 = FPRINT(MYDATE,'MtrDYY', 'A20');
COMPUTE DT6/A20 = FPRINT(MYDATE,'DMTRYY', 'A20');
COMPUTE DT7/A20 = FPRINT(MYDATE,'wrMtrDYY', 'A20');
COMPUTE DT8/A20 = FPRINT(MYDATE,'WMTDYY', 'A20');

BY COUNTRY
END

John, Vivian, does the Key Sheet show how to use the FPRINT function with date columns?

Francis,
No it does not. It shows the input as numeric format. This would work with "legacy dates" but not "Smart Dates" or "Date Time" (WebFOCUS).
Looks like I'll have to set up some tests to see what can be done with those data types. Thanks for the heads up.
Just checked the FOCUS Keysheet and it indicates any input field. The Dates book does not reference FPRINT at all - looks like I have a lot of work to do.

This message has been edited. Last edited by: John W Price,

John,

Thanks for looking into this. The IBI documentation on FPRINT is meagre.

Cheers,

Francis:

I, too, like the new FPRINT! Still need DATETRAN sometimes to get rid of those pesky commas. Add these lines and compare DT12 to DT13:

COMPUTE TEMP/YYM=MYDATE;
COMPUTE DT12/A20=FPRINT(TEMP,'MtYY','A20');
COMPUTE D13/A20=DATETRAN(TEMP,'(MYY)','(t)','EN',8,'A8');

Craig

Craig, thanks for pointing that out. Here's another way to eliminate the pesky comma:

COMPUTE DT11/A9 = EDIT(FPRINT(TEMP,'MtYY','A9'),'999$99999');

Francis:

Now I like that A LOT better than DATETRAN! Scares me that the straightforward sometimes escapes me!

Thanks...

Craig

Hi all,

Problem got solved.

As Francis Mariani said its got resolved.

Thanks to everyone.....