iTeachSAP Posted July 15, 2013 Report Posted July 15, 2013 [quote name='ganeee' timestamp='1373914307' post='1303954559'] etla vunnar bayya.............anta manche naaa.....................fullbusy annukunta emadhya................. [/quote] mari antha busy emi ledhu one week nunchi .. oka support work ayipoyindhi ...taking rest before starting another one.. ni work ela untundhi ? kotha athanu niku baaga help chesthunada ? Comfort ayava ? kotha tools tho ?
gandhi Posted July 15, 2013 Report Posted July 15, 2013 nadustundi bayya .................a project inka start kalledu.............vere project payna pani chestunna..............universe adn reports payna working ippudu.............dashboard inko 1 month padutadi anukunta start kavadaniki................
iTeachSAP Posted July 15, 2013 Report Posted July 15, 2013 [quote name='ganeee' timestamp='1373914573' post='1303954606'] nadustundi bayya .................a project inka start kalledu.............vere project payna pani chestunna..............universe adn reports payna working ippudu.............dashboard inko 1 month padutadi anukunta start kavadaniki................ [/quote] good.. ee lopala..comfortable avuu kotha tools midha.. happy working
monster999 Posted July 16, 2013 Author Report Posted July 16, 2013 bhayya keka meeru.... formulae work Ayindi tested by different runtime variables .thanks a lot bhayya....
iTeachSAP Posted July 16, 2013 Report Posted July 16, 2013 [quote name='monster999' timestamp='1373963080' post='1303957932'] bhayya keka meeru.... formulae work Ayindi tested by different runtime variables .thanks a lot bhayya.... [/quote] vooo .. good bro .. work ayindhi .. thats it man [size=4] [/size]
monster999 Posted July 16, 2013 Author Report Posted July 16, 2013 konchem a second condition cheppa ra brother....to date 31/12/9999
iTeachSAP Posted July 16, 2013 Report Posted July 16, 2013 [quote name='monster999' timestamp='1373978728' post='1303958420'] konchem a second condition cheppa ra brother....to date 31/12/9999 [/quote] Emi ledhu mama.. [b]End date [/b]Null ayinapudu , I am taking largest date i.e, [b]31/12/9999[/b] ... Iga adhemo character lo undhi .. anduke date loki convert cheyali , ledante error vesthundhi ...
iTeachSAP Posted July 16, 2013 Report Posted July 16, 2013 [quote name='monster999' timestamp='1373984204' post='1303958673'] ok thanks bro.... u rock [/quote] any time !!! [img]http://www.chalanachithram.com/discus/clipart/smoke12.gif[/img]
monster999 Posted August 29, 2013 Author Report Posted August 29, 2013 bhayya need ur help bro... [color=#444444][font=Calibri, sans-serif][size=4]=If([WO System Status]="A";DaysBetween(If(Year([Max CD])=9999 And IsNull([Max MD]);[Max DI];If(IsNull([Max DI]) And Year([Max CD])=9999 ;[Max MD];If(IsNull([Max DI]) And IsNull([Max MD]);[Max CD];[/size][/font][/color][color=#ff0000][font=Calibri, sans-serif][size=4]If(IsNull([Max DI]) And Year([Max CD])=9999;[Creation Date];If(Year([Max CD])=9999 And IsNull([Max MD]);[Creation Date];If(Substr([Work Group];1;2)="CN" And Year([Max CD])=9999;[Creation Date];[Max CD][/size][/font][/color][color=#444444][font=Calibri, sans-serif][size=4]))))));[Actual Finish Ts]);DaysBetween(If(Year([Max CD])=9999 And IsNull([Max MD]);[Max DI];If(IsNull([Max DI]) And Year([Max CD])=9999 ;[Max MD];If(IsNull([Max DI]) And IsNull([Max MD]);[Max CD];[/size][/font][/color][color=#ff0000][font=Calibri, sans-serif][size=4]If(IsNull([Max DI]) And Year([Max CD])=9999;[Creation Date];If(Year([Max CD])=9999 And IsNull([Max MD]);[Creation Date];If(Substr([Work Group];1;2)="CN" And Year([Max CD])=9999;[Creation Date];[Max CD][/size][/font][/color][color=#444444][font=Calibri, sans-serif][size=4]))))));CurrentDate()))[/size][/font][/color] [font=Calibri, sans-serif][color=#444444][size=4]Bhayya red color lo conditions satisfy kavadam ledu please let me know where i'm gng wrong....and i can use only if conditions bhayya ....[/size][/color][/font]
Yuva Nataratna Posted August 29, 2013 Report Posted August 29, 2013 [quote name='iTeachSAP' timestamp='1373978285' post='1303958412'] vooo .. good bro .. work ayindhi .. thats it man [/quote] ..
Recommended Posts