cancel
Showing results for 
Search instead for 
Did you mean: 

how to convert date value(format) in Calendar(input controls)

Former Member
0 Kudos

Hi everyone

I am using webi 4.0

My problem is when i select calendar date(input Controls) i am able to display time stamp along with date in input Controls(MM/dd/yyyy 12:00:00 AM)

i want to change (MM/dd/yyyy 12:00:00 AM) to (yyyy-MM-dd ), when i select calendar date(input Controls)

where is the calendar date(input Controls)' format setting??

i dont want to show the time stamp in calendar date(input Controls) as my users dislike to see that timestamp .

Thanks & regards

'Before'

'After'  ( i want to change 'Before' to 'After')

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member207878
Active Participant
0 Kudos

Hi Yongho,

Create a variable and change the format of your date dimension in that variable. And use that variable in your Input Control.

former_member195290
Contributor
0 Kudos

Hi Park,

Create a new variable on the Calendar Date object and edit it using FormatDate function and use that object for input control.

=FormatDate([Date];"yyyy-MM-dd")

Regards,

Javed

former_member207878
Active Participant
0 Kudos

Javed,

Just one more correction in your formula:

=ToDate(FormatDate([Date];"yyyy-MM-dd");"yyyy-MM-dd")

With this, we will get calendar in our input control as well.