How to change the date format

bobnavisionbobnavision Member Posts: 159
Hi

How do we change the date format of a date field from MM/DD/YYYY
to DD/MM/YYYY while importing it from dataport.

Regards,

Comments

  • JedrzejTJedrzejT Member Posts: 267
    if this dataport is use to import date few times you can change date format in regional setting ,import and change format again.

    other way:

    insert text variable instead field in dataport fields

    datefield:=DMY2DATE( COPYSTR(txtvar,4,2) .
    COPYSTR(txtvar,1,2) .
    COPYSTR(txtvar,7,4) )
Sign In or Register to comment.