Export Wizard - Toad Data Point v3.3

Toad Data Point
1

Dear All,

I am currently making use of TDP v3.3 to report on data using xlsm templates.

For this an export wizard has been created which uses the xlsm template and certain macros are run both before & After the export.

Data seems to be dumping fine and macros also seem to be executing well.

The problem that I am facing using the export wizard is that when I try to save the xlsm template with a date time stamp, it seems to be defaulting timestamp as per 12HR clock and not 24HR. This is now causing problems as the batch is scheduled every 1 hour.

Any suggestions!

Thank You!

Regards,

Prashant

2

In 3.3 you now have richer functionality for suffixing. To get 24-hours time formatting you should slightly change the default DateTime formatter string:

DateTime(‘YYYY-MM-DD HH24-MI-SS’)

Igor.

3

Dear Igor,

Thank you for your reply.

I did try that option while using the script to file and it works.

However, I have not been able to get that working using the Export Wizard.

Every time I try and change it to 24HR format after saving it reverts to 12HR standard.

Any suggestions.

Thanks!

Regards,

Prashant

4

It is a bug. I created CR111334 to track this issue.

Igor.

5

Dear Igor,

Thank you for your reply.

Hopefully, it would be rolled out as an update.

Regards,

Prashant