DateRange Picker

[yogita.magdum]

Hi,

How to convert start date and end date epoch time to actual date time format

[pinky1]

Hi @yogita.magdum,

You can bind the date & time picker control to custom formula where you can use the formula DATESTR(1624492800000,“DD-MM-YYYY HH:mm” , 1)

Also, sharing an article on using date & time functions for your easy reference.

Date & Time Functions

Supported functions related to Date and Time DronaHQ Studio supports the following Date and Time-related functions DATESTR() This is a custom function that converts date (Unix format) to readable date format, say, 29/Apr/2019. Syntax - DATESTR(date,format,isLocalTime) where date is a UNIX date format can be any of the following keywords - "dddd" will return Monday "ddd" will return Mon "dd" will return Mo "d" will return 1 "DD" will return 29 “MM” will return 04 "M" will return 4…

OR

You can achieve the desired format by using custom javascript from the data section. Attached is the screenshot for your reference.

Also, sharing an article on transforming unix format to string Transforming UNIX format to String format

I hope this helps.

Best,

Pinky

[bhanuprasad.ippili99]

Hi,
How to add today, yesterday, this week, this month and custom date range in DateRange Picker.

[Avinash]

Hi @bhanuprasad.ippili99 ,

To add these mentioned functionalities/shortcuts in a Date Range Picker, we have the option to toggle on the Enable shortcuts property in the properties section of the Date Range Picker control. When we toggle it on, we can see these options on the left in the modal of the Date Range Picker.

Here I add the relevant article link for Date Range Picker control.

Date Range Picker | Build stunning internal tools, blazing fast

Thanks.