Remove time portion of Date property value

[Anonymous]

I have a rule that grabs the value of a particular custom date property and sets another custom date property to that value when the rule is run.

Date Property B = Date Property A

My problem is this: sometimes the value of Date Property A contains the time. When I copy this value to Property B, and property B is used to create a folder path, it causes problems. Is there a way I can strip the time out of the property value? BTW, the time does not show in the properties dialog in IV.

Custom Property dialog

Actual value of property

My code looks like this:

'Some Code

oToday = iProperties.Value("Custom", "Rev Date")

iProperties.Value("Custom", "Dwg Request Date") = oToday

'Some Code

If there was some string split function I could perform on oToday, to strip the time off the end it would be great.

Anybody have any ideas?

[cmcconnell]

Sorry - this was posted by me with the wrong account. :(

[lmc.engineering · Accepted solution]

Hi @cmcconnell

You can use a split function on the string and take the first instance of the new string:

SyntaxEditor Code Snippet

oToday = "11/2/2018 9:53:25 AM"
myString = oToday
sDate = myString.Split(" ") (0)

[bradeneuropeArthur]

1. Today.year
2. Today.month
3. Today.day

[cmcconnell]

I was able to get this to work using your solution - thanks!

[bradeneuropeArthur]

maybe this is much easier

msgbox (date.Today)