- This topic is empty.
- 05/16/2013 at 10:39 am #5416
i have been wondering and what i need is a calculated column of type date that does the above comparation
i have written the following: =IF(Expires=1/1/2013,Expiration,Expires) i want that if expires=1/1/2013 have "Expiration" and if "Expire" isnt equal to 1/1/2013 then have "Expires"
- 05/17/2013 at 8:02 am #4426
i have an announcement list that has the incoming e-mail settings activated. the “Expires” column is a default column for incoming email settings.
this list has two possibles inputs, the first way by manual input, and the second way by incoming e-mail.
the problem that i have is the incoming e-mail hasn’t got any default expiration date field, so when a e-mail is received, i have a calculated column of type date called “Expiration”(gets data from “modified” field ) and the “Expires” column will be in blank for an email. and for the manual input, the “Expires” column and the “Expiration” column are both used when in this case the “Expires” info is the one that i want to use.
so the problem is with the manual input that will have probably different information from “Expires” and “Expiration” fields
what i mean is for example how to filter the list with 2 criterias, so first filter the items by “Expiration” when they haven’t got “Expires” information and secondly if it has “Expires” info then filter it.
i whant a filter like this in my list
if(column(Expires)==null) //email input
else //manual input
- 05/17/2013 at 8:02 am #6147
Now it works Outage calculated column of type date with the following formula:
test calculated column type date, with Todays date.
Expires manual input type date.
Expiration automatic data type date.
You must be logged in to reply to this topic.