Converting strings to dates in Integration Manager

(0) Share

Report

Posted on by Richard Wheeler

75,730

I have a csv file with a datetime string. The format is MMDDYYHHMMSS. I need to extract the date and import it into the SOP date field. An example is:

10152020040828

sDateValue = SourceFields(MID("SOP Header.F10",1,2))+ "/" + SourceFields(MID("SOP Header.F10",3,2))+ "/" +SourceFields(MID("SOP Header.F10",5,4))

I keep getting invalid date format.

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: Converting strings to dates in Integration Manager

This does not work either. All I get are blank dates

'Now build the date from the full date string

sDay = SourceFields(MID("SOP Header.F10",3,2))

sMonth = SourceFields(MID("SOP Header.F10",1,2))

sYear = SourceFields(MID("SOP Header.F10",5,4))

sDate = sMonth + "/" + sDay + "/" + sYear

'Set the value to return to date

CurrentField.Value = sDate