Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello!
Can you write table with some data for example.
Thnks
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]
Hi,
Some data maybe handy, but when i used isNull() i will always check IsNull()=-1, -1 is null 0 is not null
Mark
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]
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]
The null i am referring to is an empty cell in a spread sheet,
it is still the same
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.
is still not giving me the three status on the list box but two
only Submitted and to be submitted