Ageing Analysis Report issues

[#1]

Hi,

i am trying to do ageing analysis based on the dates available in the field.

Ex:

IF

(Today()- Date(MakeDate(Year(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY')),Month(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY'))), 'MM/DD/YYYY') = 0,'Today',
IF(Today()- Date(MakeDate(Year(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY')),Month(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY'))), 'MM/DD/YYYY') = 1,'1day',) )As OpenTime

I have modified the format of data and when i use this in expression in the report it returns me the number but when i upload it in main edit script page and reload the script, i dont get any values in newly created 'OpenTime' column.

Please guide.

[#2]

expression

Today()- Date(MakeDate(Year(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY')),Month(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY'))), 'MM/DD/YYYY')

gives 0 if today()=first day of month and [Submit Date] = today()

gives 1 if today()=second day of month and [Submit Date] = yesterday

what i mean is your condition probably never is true