UX - Date Formatting

Apliqo UX
1

Hi,

My TM1 formatting for a column is setup as following to show a calendar picklist:

image
image1837Ă—884 182 KB

I am trying to get this to flow through to UX but it does not work, is there special formatting needed in UX to pick this up? Or a way to recreate what PAW can do? It is also causing the zero suppression not to work.

image
image1008Ă—656 53 KB

Thanks Ronan

2

Hi Ronan,

For UX to format the cell as Date picker, create a string Attribute named “CellType”, and put “Date” on it.

image
image845Ă—226 11.9 KB

This will then make the Cell input to be a Date picker.

image
image931Ă—458 40.8 KB

Hope this helps!

Rodrigo

1 Like
3

Thanks that’s it working now. For any readers out there, the element also has to be a string (mine was numeric and that’s why it didn’t work initially).

1 Like
4

Thanks @rgallagher that’s something I think we should probably fix. It’s pretty common to store date/timstamps in index format and just display time-date formatting. This is something we should support. The question then comes which date epoch the index value should use as this would need to be defined as a property of the date picker. (e.g. Excel 1899-12-30 = 0, Unix 1970-01-01 = 0, or something else).

1 Like