Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Change Time Picker from 24hr to 12hr

How do i change the date and time picker from 24-hr to 12-hr format.


This is what is already in the data card:

DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)


I located a previous solution, when I enter this it does not work:


AmPmValue1.Items: ["AM", "PM"]
AmPmValue1.Default: If(Hour(Parent.Default) < 12, "AM", "PM")
HourValue1.Items: ["12","01","02","03","04","05","06","07","08","09","10","11"]
HourValue1.Default: Text(If(Mod(Hour(Parent.Default), 12) = 0, 12, Mod(Hour(Parent.Default), 12)),"00")
DataCard1.Update: DateValue1.SelectedDate + Time(If(AmPmValue1.Selected.Value = "PM", 12, 0) + Mod(Value(HourValue1.Selected.Value), 12), Value(MinuteValue1.Selected.Value), 0)


This link that references a formula doesn't tell you how to insert to change:



Please help!


Accepted Solutions


All of the code does not get pasted in a single control.  You need to put the code in each control/property.

View solution in original post

Super User III
Super User III


I have copied and pasted the code you supplied into a test app and everything works fine for me.   Your post says your code does not work.  Could you please tell me what specifically does not work with your code?

Where in the card does this code get pasted into?
Is it when the card is selected? the one that includes the hrs and minutes?


Frequent Visitor

When I insert the code it shows error, see screen shots.


Bid Date 1.PNGBid Date 2.PNG


All of the code does not get pasted in a single control.  You need to put the code in each control/property.

View solution in original post

Frequent Visitor

Ah, thank you. Once you mentioned it needed to be broken down I was able to make adjustments successfully.

Frequent Visitor

hello @mdevaney ,


I am just now catching and issue. I separated the update like you previously mentioned, but now when PM is selected it automatically changes to AM once you submit. Why isn't the PM working?




Your last post on this thread was over a month ago.  I suggest you create a new thread and explain the problem you are now having there instead.


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (15,973)