set DateAdd in Screen Simple Value

lock
push_pin
done
Answered
2

Hi,

In the Custom Screen for 'Edit Ticket' i can define specialized List in Simple Value to display filtered project List related to Tickets:

Now I want to display a Date-Field UDF of Project in this Project List. in SO Datebase the Date-Field is stored with a large number. Then i try to convert it as a Date:

Now I click Edit Ticket and by seaching in Project list, it pops up with an Error:

Question is, how could i convert to display a date-field from a large number in Screen Simply Value?

 

Thanks for your Helps.

24 Sep 2025 | 09:08 AM

All Replies (2)

This is not possible, there are no functions here to automatically convert the unix timestamp (format how a date UD field is stored in the database) to display value.

2 Oct 2025 | 09:58 AM

Hi David, yes, in Simple Value it can only display the original Data stored in DB Fields and no more, even without any simple Operator.

For Working Around I created a read-only UDF with String-Feld and copy the Value of UDF Date-Field in this UDF String-Field by Trigger "After Saving Project":

Then in Custom Screen in Simple Value for the Project-List related to Ticktes, it displays the UDF of String-Feld, and sort by UDF of Date-Field. It works.

Now I found another Isses in Simple Value: it doesn't works to sort with desc, that means, i cannot list Projects with current date at first.

order.0.desc = 1
order.0.field = project.userdef_id.long05
order.length = 1

 

Do you have Idea?

Thanks!

 

20 h, 0 m ago | 08:53 PM
got it:
order.0.desc = true
19 h, 31 m ago | 09:22 PM

Add reply