Problem with General Date Field

[ErinL]

Hello -

I have a field called ScheduledDepart that is a General Date format. I have a second field called ScheduledDepartWithCushion that is a calculated General Date formatted field that adds 1 hour to the Scheduled Depart field. When the calculated field has a time of midnight the time does not show in the field. Below are examples of the data in the fields and how the calculated field looks.

ScheduledDepart ScheduledDepartWithCushion
10/22/2018 10:00:00 PM 10/22/2018 11:00:00 PM
10/22/2018 11:00:00 PM 10/23/2018

How can I get the midnight to show on line two?

Thank you!

 

[theDBguy]

Hi,

You might have to try using other formats. Last resort is to dictate exactly what you want. For example: "mm/dd/yyyy hh:nn:ss AMPM"

 

[ErinL]

Wow! I have been trying different things since yesterday and couldn't get it to work. I tried formatting it previously with just "General Date" as the format type and it didn't show. Now I formatted and added the exact format as you suggested and it works perfectly! Why didn't I think of that?

Thank you so much for your quick response!

 

[theDBguy]

Hi,
You're welcome. Glad to hear you got it sorted out. Good luck with your project.