Date field with only day and month
I have a table with the names of employees and the date their performance appraisal is due. Since they're due annually, I'd like the date to read just the month and day. Is this possible? And then cre...
Forum Discussion
You can create your own formula text field to have some text like JUN 17
var date MyDate = [Due Date];
List(" ",
Case(Month($MyDate),
1,"JAN",
2,"FEB",
3,"MAR",
4,"APR",
5,"MAY",
6,"JUN",
7,"JUL",
8,"AUG",
9,"SEP",
10,"OCT",
11,"NOV",
12,"DEC"),
ToText(Day($MyDate)))
As for the automated email, if you just want a single email you can use a Reminder
https://help.quickbase.com/user-assistance/creating_a_reminder.html
or else create a report filtered where the [userid to be reminded] is the current user
and
[due date] is on or before 14 days in the future.
Then you subscribe all managers ot that Report Subscription.
var date MyDate = [Due Date];
List(" ",
Case(Month($MyDate),
1,"JAN",
2,"FEB",
3,"MAR",
4,"APR",
5,"MAY",
6,"JUN",
7,"JUL",
8,"AUG",
9,"SEP",
10,"OCT",
11,"NOV",
12,"DEC"),
ToText(Day($MyDate)))
As for the automated email, if you just want a single email you can use a Reminder
https://help.quickbase.com/user-assistance/creating_a_reminder.html
or else create a report filtered where the [userid to be reminded] is the current user
and
[due date] is on or before 14 days in the future.
Then you subscribe all managers ot that Report Subscription.