Extract only the time

Need help Database
1

I have a date picker (without time picker). The input type is only date so time should not be a concern. However, when I try and display Current page group's Date, I get Aug 28, 2021 12:00 am.

Why is it showing me a time and how can I get rid of it?

Separately, I have a date and time picker and need to display only the time in this one. However, when I try, I get things like 12 instead of 12:34pm.

Anyone familiar with how to properly extract date and time from the standard pickers?

2

Instead of :extract hour/min you want to use :format as 1979

3

Hi,

Try to use :formatted as Date, it will show different way of formatting your datetime value with prefered timezone.

image
image716×445 21.1 KB

2 Likes
4

Thanks. I wasn’t sure what you meant by ‘1979’ as that isn’t an option, but I found formatting as Tue, Aug 31, 2021 worked. Similarly, to extract the time only, I found formatting as 3:45pm worked.

Absolutely no idea why I didn’t figure this out, I spent a good 5 hours on this bloody issue! Crazy!