Timestamp on published date selector control in SharePoint workflo

[nwader]

A brain-racking problem I have right now (and it may just be a problem with
SPD and not Infopath) is I have a date picker on a form which is published as
a column to a SharePoint library. When the value from the form is displayed
in the SharePoint list it shows up fine, but when generate an email using a
workflow with that date picker value referenced it includes a 12:00 AM
timestamp in there as well. I can't figure out how to get rid of this
because the format in Infopath does not include the time. Any help is
greatly appreciated.

 

[Swathi (GGK Tech)]

Hi,
In SharePoint there is no only date data type. It includes Date and Time as
the data type. That is why it is giving the date with time. If you are using
code in workflow, then use substring of that field to get the date value.
If you want the time to include in the InfoPath form also then change the
data type of date picker to Date and Time and set the format.

 

[nwader]

Any idea why the timestamp isn't working properly? It always come up as
12:00 AM and not the actual time. I'd have less of a problem doing a date
lookup and having the actual time be sent in an email to our users but the
fact that it is always midnight is what is bothering me.

thanks for the reply,

 

[Shiva (GGK Tech)]

Hello,

By default value is 12:00 AM as in date time field. If you want to exact
time then we have to store that value in the format of time includes.

 

[nwader]

That worked beautifly. Thx for the idea. I accomplished this using the
following:
concat(number(substring(dteDesiredPickup, 6, 2)), "/",
number(substring(dteDesiredPickup, 9, 2)), "/",
number(substring(dteDesiredPickup, 1, 4)))

the dteDesiredPickup is the date control on my form.