Script

[#1]

Hi All

i want to a submission status list to show the list of the following: "submitted","to be submitted" and not submitted

I have this script that is suppose to do the above but is showing only the "submitted" and "to be submitted"

if([CV Send Date]=[Closing date] ,'Submitted'

  , if( (  [Closing date] < Today() )and( IsNull( [Candidate FullName]) ) and (IsNull([CV Send Date]) ),'Not Submitted' 

   ,  if([Closing date] >= Today() , 'To be Submitted' ))) as [Submission Status]

Thanks and Regards

Priscilla

[t_chetirbok]

Hello!

Can you write table with some data for example.

Thnks

[Anonymous]

Try this:

Bold bracket need to be closed in last...

if([CV Send Date]=[Closing date] ,'Submitted'  ,

if( ([Closing date] < Today() and( IsNull( [Candidate FullName]) ) and (IsNull([CV Send Date]) )),'Not Submitted'    ,  if([Closing date] >= Today() , 'To be Submitted' ))) as [Submission Status]

[Mark_Little]

Hi,

Some data maybe handy, but when i used isNull() i will always check IsNull()=-1, -1 is null 0 is not null

Mark

[#5]

i am not good at using this message box but whant is a list of status e.g

Submission Status

Submitted

Not Submited

To be ubmitted

if([CV Send Date]=[Closing date] ,'Submitted'

  , if( (  [Closing date] < Today() )and( IsNull( [Candidate FullName]) ) and (IsNull([CV Send Date]) ),'Not Submitted'

   ,  if([Closing date] >= Today() , 'To be Submitted' ))) as [Submission Status]

[#6]

i dont know how to draw table but maybe you will get an idea:

I want a list box of submission status it must be like this:

Submission status (this is a title)

Submitted

Not Submitted

To be Submitted

and this script is giving me only two status, Submitted and to be Submitted

if([CV Send Date]=[Closing date] ,'Submitted'  ,

if( ([Closing date] < Today() and( IsNull( [Candidate FullName]) ) and (IsNull([CV Send Date]) )),'Not Submitted' 

  ,  if([Closing date] >= Today() , 'To be Submitted' ))) as [Submission Status]

[#7]

The null i am referring to is an empty cell in a spread sheet,

[#8]

it is still the same

[t_chetirbok]

ok, maybe when you write if conditions for 'Not Submitted' , try this: (IsNull( [Candidate FullName]) or [Candidate FullName]='') and (IsNull([CV Send Date]) or [CV Send Date]=0).

and for "Submitted": [CV Send Date]<=[Closing date]

If it's not right, post your filed with some data.

[#10]

is still not giving me the three status on the list box but two

only Submitted and to be submitted