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
(67.210.195.2)
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
(205.214.226.20)
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
(67.210.195.2)
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: 4544
Loc: Wynnewood, PA
(173.59.34.133)
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
0 registered (), 616 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1874 Members
5 Forums
14566 Topics
71089 Posts

Max Online: 1089 @ Yesterday at 11:03 PM
November
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