Format number in load script

[tmumaw]

Hi everyone,

Need a little help in getting my number format right in my load script.  Here is what I have.......but not working.

Thanks in advance.

Num((if(Len(trim(Acq_Hire_Date) > 0), Num(LastWorked_Date) - Num(Acq_Hire_Date), Num(LastWorked_Date) - Num(HireDate)) / 365,'00')) as [LOS]

[eespiritu]

Hi Thom,

Try this:

Num((if(Len(trim(Acq_Hire_Date) > 0), Num(LastWorked_Date) - Num(Acq_Hire_Date),Num(LastWorked_Date) - Num(HireDate)) / 365,'#,##0.00')) as [LOS]

Regards,

Enrique.

[sunny_talwar]

May be this

Num(

(If(Len(trim(Acq_Hire_Date) > 0,

     LastWorked_Date - Acq_Hire_Date,

     LastWorked_Date - HireDate)/365),

'00') as [LOS]

[Anil_Babu_Samineni]

May be try this?

If(Len(Trim(Acq_Hire_Date))>0, Num(LastWorked_Date - Acq_Hire_Date), Num((LastWorked_Date - HireDate)/365)) as LOS

Split to diff expressions and then try

[tmumaw]

nope

[tmumaw]

nope

[sunny_talwar]

Can you share a screenshot?

[Anonymous]

Num((if(isnull(Acq_Hire_Date),Num(LastWorked_Date) - Num(HireDate), Num(LastWorked_Date) - Num(Acq_Hire_Date)) / 365,'00')) as [LOS]

[tmumaw · Accepted solution]

Got it to work.  Thanks everyone for your help.

Num((if(Len(trim(Acq_Hire_Date) > 0), Num(LastWorked_Date) - Num(Acq_Hire_Date), Num(LastWorked_Date) - Num(HireDate)) / 365),'00') as [LOS] 

[sunny_talwar]

Great, if you got what you wanted, I would suggest closing this thread by marking your own response as the correct answer.

Best,

Sunny