Topic Options
#42966 - 09/09/14 01:52 PM Gridview export / format question
Davis Offline
Casual

Registered: 10/10/13
Posts: 13
Loc: Madras, Oregon USA
Need to export a .csv file, looking for date format MMDDYYYY, don't see this as an available format. Can you create a custom ?

Top
#42969 - 09/09/14 02:16 PM Re: Gridview export / format question [Re: Davis]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Use:
Code:
DATESTRING({Date},"%m%d%Y")
_________________________
Andrew Bates

Top
#42970 - 09/09/14 03:34 PM Re: Gridview export / format question [Re: Retired_Guy]
Davis Offline
Casual

Registered: 10/10/13
Posts: 13
Loc: Madras, Oregon USA
Thanks Andrew!

Top
#42972 - 09/10/14 04:58 AM Re: Gridview export / format question [Re: Davis]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4510
Loc: Wynnewood, PA
Hi Davis

For my clients who need to manipulate CSV files, I recommend a great utility program called Killink CSV by White Peak Software. For a small price, it does amazing things.

Excel can supposedly handle CSV files, but it often mangles them. Killink looks and works like Excel but preserves the integrity of CSV files.

Steve

Top


Moderator:  Softrak Support 
Who's Online
1 registered (Softrak Support), 72 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14461 Topics
70641 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30