Date and Time Format

[david.allan.johnson@redsa]

I have a Date text box that will display the date in the following format 12/18/2024 5:00:00 PM. Is there away to remove the 2 digit seconds numbers and add text within the string? For example, I would like it to be in the following format: 12/18/2024 at 5:00 PM.

Thanks,

 

[theDBguy]

You could try using the Format property of the textbox.

BTW. Welcome to AWF!

 

[david.allan.johnson@redsa]

You could try using the Format property of the textbox.

BTW. Welcome to AWF!

Thanks

 

[david.allan.johnson@redsa]

Thanks

As a start, I tried MeetingStartDate = Format([MeetingStartDate], "mm/dd/yy") , but it still displays a 4 digit year. Any ideas?

 

[Gasman]

As a start, I tried MeetingStartDate = Format([MeetingStartDate], "mm/dd/yy") , but it still displays a 4 digit year. Any ideas?

That is strange?

?Format(Date(), "mm/dd/yy") ,
12/19/24

 

[Isaac]

As a start, I tried MeetingStartDate = Format([MeetingStartDate], "mm/dd/yy") , but it still displays a 4 digit year. Any ideas?

That's probably because Format returns a String, which can't overcome the fact that your textbox is bound to a Date datatype. You have to think of underlying datatypes and what functions return.

 

[david.allan.johnson@redsa]

That is strange?

?Format(Date(), "mm/dd/yy") ,
12/19/24

I tried Format(Date, "mm/dd/yy") and I'm still getting a 12/19/2024. Should I enter the format in my query?

 

[theDBguy]

As a start, I tried MeetingStartDate = Format([MeetingStartDate], "mm/dd/yy") , but it still displays a 4 digit year. Any ideas?

Here's what I mean...

 

[Gasman]

I tried Format(Date, "mm/dd/yy") and I'm still getting a 12/19/2024. Should I enter the format in my query?

That will still create a string?

 

[david.allan.johnson@redsa]

Here's what I mean...
View attachment 117564
View attachment 117565
View attachment 117567

Ok, thanks. I'll try that.

 

[david.allan.johnson@redsa]

Here's what I mean...
View attachment 117564
View attachment 117565
View attachment 117567

That worked . Thanks so much. You're a genius!

 

[Isaac]

I tried Format(Date, "mm/dd/yy") and I'm still getting a 12/19/2024. Should I enter the format in my query?

it's a lesson to think about datatypes and how they flow through the different layers of Access.

Yes, if you used Format() in your query, and created a form textbox bound to it, it would honor the Format() request because it's a string.

 

[Pat Hartman]

The suggestion was to set the Format PROPERTY of the control, NOT to use the Format() function.