IF THEN STATEMENT 1

[danielcan]

Good day ladies and gentlemen

I have a question about if then statement. I have a time field name easttimeof. I am trying to write a simple code in the after up date that If easttimeof = "12:00:00 AM" Then easttimeof = "00:00:01 AM" .

In other words if 12:00:00 AM:shows up I want it to be converted to 00:00:01 AM. How do I right the time per say in my code in bracket, comas ....????

Thank you all for your wisdom
Daniel

 

[SkipVought]

Hi,

If easttimeof = #12:00:00 AM# Then easttimeof = #00:00:01 AM#

or

If easttimeof = #12:00:00# Then easttimeof = #00:00:01#

Time is not STRING. It is DATE.

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[danielcan]

Sir I thank you

You are in my gratitude.

Daniel Belanger