Reverse MoveDate_ format

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Reverse MoveDate_ format

Post by Kristen » Thu Nov 19, 2009 2:18 pm

If you would like to reverse the format of the MoveDate_ field so that it is month then year:

ie. you want to change it from 200902 to 022009, you can run the following command:

Code: Select all

Replace all movedate_ with SUBSTR(movedate_,5,2)+LEFT(movedate_,4)

Post Reply