345
Wells Fargo bank requires the date format to be MM-DD-YYYY (needs dashes, not slashes) however this is not a format option. We have a lot of clients that use Wells Fargo bank, so we would like to see this format added to the field format options.
Are there any workarounds in the meantime?
*This post is locked for comments
Mike,
As Leslie mentioned , there is seems to be no option to use calculation when defining the output fields. One work around is you do it outside the GP. You can use MM/DD/YYYY in the format in GP for all date fields and write a batch script to replace the “/” with “-” in the output file. You can use the simple find and replace script if you are sure there will be no “/” in other fields. Otherwise you will need to you the regular expressions to find date and replace them.
Rubal,
use following function....
date2str(YourDate, 123, DateDay::Digits2, DateSeparator::Hyphen, DateMonth::Digits2, DateSeparator::Hyphen, DateYear::Digits4));
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (