Calling Iteachsap.....

[monster999]

hi dude,


can you please help me with this report ,

I need to display only the date when the work order was finished....i tried creating variable by using if condition but none works...is there any other way we can approach like using foreach or forall to define calculation context....I need the report to be submit tomorrow...

[monster999]

WORK ORDER NUMBER ACTUAL START DATE ACTUAL FINISH DATE EMP START DATE EMP STOP DATE ACTUAL W O START TIME ACTUAL WO FINISH TIME EMP ID COMPLETED BY 2383452 14/07/2013 14/07/2013 01/12/2012 19/11/2012 NT00213 NT00213 2383452 14/07/2013 14/07/2013 23/12/2012 04/03/2013 NT00213 NT00213 2383452 14/07/2013 14/07/2013 05/04/2013 NULL NT00213 NT00213 2383453 23/06/2013 23/06/2013 12/11/2012 14/03/2013 NT00453 NT00453 2383453 23/06/2013 23/06/2013 16/03/2013 NULL NT00453 NT00453 2383454 11/06/2013 11/06/2013 13/11/2012 04/05/2013 NT00876 NT00876 2383454 11/06/2013 11/06/2013 06/05/2013 12/06/2013 NT00876 NT00876 11/06/2013 11/06/2013 15/06/2013 NULL NT00876 NT00876

[iTeachSAP]

nuvvu raasina formula ikkada vesukoo brother ... WEBI lo chesthunava report ?

[monster999]

hi bro,

i sent u a mail.....please check it....

[color=#444444][font=Calibri, sans-serif][size=4]=If( [Actual Finish Date] Between([Start Date];[Stop Date]) ;"yes";If (IsNull([Stop Date]) ;"yes";"no"))[/size][/font][/color]

[monster999]

yeah webi only....can't use where as well other than where ....

[gandhi]

[quote name='iTeachSAP' timestamp='1373910803' post='1303954093']
nuvvu raasina formula ikkada vesukoo brother ... WEBI lo chesthunava report ?
[/quote]

[iTeachSAP]

[quote name='monster999' timestamp='1373911342' post='1303954162']
hi bro,

i sent u a mail.....please check it....

[color=#444444][font=Calibri, sans-serif][size=4]=If( [Actual Finish Date] Between([Start Date];[Stop Date]) ;"yes";If (IsNull([Stop Date]) ;"yes";"no"))[/size][/font][/color]
[/quote]


Ni question first of all clear gaaa ardham kaaledhu mama ..

from the above formula, this is wat my understanding is..

Actual finish date with in the start date and stop date lo unte "Yes " chupinchaali .. ledha no ani chupinchaadu .. anthe naa?

[monster999]

yeah ......i sent an image to ur mail to itrainsap....please check it u can get clear...

[iTeachSAP]

Bro .. I will get back to you on this.. give me couple of mins. I am working on it..

[iTeachSAP]

[quote]=If(DaysBetween([Start Date];[Actual Finish Date]) >0 and
DaysBetween([Actual Finish Date];IF(ISNULL([Stop Date]);ToDate("31/12/9999";"dd/MM/yyyy");[Stop Date])) >0
;
"Yes"
;
"No")[/quote]

[iTeachSAP]

use the above formula as it is.. niku emaina syntax error vasthe naaku cheppu ..

[iTeachSAP]

[quote name='ganeee' timestamp='1373911516' post='1303954185']

[/quote]

[monster999]

ok bro sure will try that .....thanks alot bhayya....

[iTeachSAP]

[quote name='monster999' timestamp='1373913143' post='1303954357']
ok bro sure will try that .....thanks alot bhayya....
[/quote]


any time AFDB bayya... let me know if it does work ..

[gandhi]

[quote name='iTeachSAP' timestamp='1373912870' post='1303954319']


[/quote]

etla vunnar bayya.............anta manche naaa.....................fullbusy annukunta emadhya.................