Question:
We have a field in a BEX query output that displays date in MMDDYYYY format.
We would like to display this instead as FP/FYEAR (fiscal period/fiscal year).
Same data, just display differently.
What is the way to do this in Query Designer?
Cheers!
Answer:
why don't you fill an extra InfoObject (0FISCPER) in your update rules?
Answer:
Is there a way to accomplish the same in BEX, analogous to the date conversion functions in say, Oracle or Access?
We do have 0FISCPER, as a separate characteristic.
Is the suggestion to add 0FISCPER as an additional attribute of the characteristic that currently has calendar day?
Answer:
if you have 0FISCPER, why not show it?
I don't see the actual problem I guess...
Answer:
Will try & see the results.
Thanks!
Answer:
The challenge is this:
We need to subtract one calendar date from another calendar date to obtain the number of fiscal periods that elapsed between.
How to convert that "difference" into the number of fiscal periods?
Answer:
are you the same guest of the initial post? 'cause this is something completely different...