Jump to content
Innov

Using the Date as an Excel Filename

Recommended Posts

Hi,

Just wondering if anyone can help I'm using a V350 with TRA22 expansion. I'm trying to use the date as a file name for saving a CSV excel file?

Currently I use the RTC (dd/mm/yy) to ASCII and save the result in an ML and try to use this as an indirect input into the delimited line but this gives status error 2: Fail to Open File. I think its to do with the "/" that gets stored in the ASCII number, as i tried experimenting with this using constant text and got the same error status. I'm wondering if there is a work around for this?

I think i can use either vectors to fill in the date using the relevant SI bits(32 and 33) but im not sure how to fill up the vector correctly? Or I could use the String Remove function to remove the "/" from the RTC to ASCII conversion but again i'm not sure how to do this correctly?

Hoping someone can point me in the right direction :)

Cheers,

Innov

Share this post


Link to post
Share on other sites

Hi,

Came up with a workaround I just multiplied the SI 32 (DDMM) by 10000 then adding in SI33 (YYYY) and performed a NUM to ASCII conversion and this gave the date that can be stored as a filename.

Might help someone in the future :)

Cheers,

Innov

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...