Using vbld_FormatDateEx

[Too_Tall_Crown_Victoria]

Can you provide a sample script that uses this function and returns the value in the following format?

vbld_FormatDateEx(%DATE%, "yyyy-mm-dd")


Also how can I get the format for yesterday and for 7 days ago?

Thanks

Tom

[kinook]

Attached.

[Too_Tall_Crown_Victoria]

Can I use [vbld_FormatDateEx(Now, "yyyy-mm-dd")] in a set macro directly or does it have to be set via some script?

Also I am getting " 'Now' is undefined" when using your script.

Tom

[kinook]

Originally posted by Too_Tall_Crown_Victoria
Can I use [vbld_FormatDateEx(Now, "yyyy-mm-dd")] in a set macro directly

Yes.

Also I am getting " 'Now' is undefined" when using your script.

Is VBScript your default script language (Tools | Application Options | General)? Please ZIP and send or post:
1) The info from Help | About | Install Info
2) The .bld file
3) A build log file

Thanks.

[Too_Tall_Crown_Victoria]

My App is set to use JScript since I have a bunch of global JScripts that I use.

I have also figured out how to solve my problem.

What I still don't understand is how to use your vbld_FormatDateEx in a JScript Script action or a Set Macro step.

Thanks

Tom

[kinook]

Neither Now nor the vbld_FormatDateEx system script function are available to JScript.

One option would be to add a Run Script (VBScript) step. To create/update a macro from such a step, you could use something like:

Application.Macros(vbldMacroTemporary).Add "NAME", vbld_FormatDateEx(Now, "yyyy-mm-dd")