Validating Dataport date Field

bobnavision · 2006-03-21

I have to import a CSV file through dataport in which there is a date field which can be in DD/MM/YYYY or MM/DD/YYYY format.
Program give an error which is obvious if its not in DD/MM/YYYY.

Data can come in both formats , how do we import the date ?

Regards,

kine · 2006-03-21

You need to add some code to format the data in OnBeforeEvaluate where you can change the readed data and format them to correct format. This trigger can be accessed from Dataport Fields by pressing F9 for the selected field.

Validating Dataport date Field

Comments

Categories