• Page:
  • 1
  • 2

TOPIC: date variable formatting

date variable formatting 07 Mar 2008 01:33 #118

  • hcornell
  • hcornell's Avatar
I am using this software to export a file daily to pdf. I am archiving the old files, and would like to be able to sort them according to the date in the filename rather than the file system date. For that I need the following format: YYYYMMDD. However, the Current Date variable shows up like: 3-4-2008.

I tried hardcoding the year, then putting in Current Month Number and Current Day number, but then I get the following: 200834. How do I get 2-digit month and day numbers in the variable?

Thank you
The administrator has disabled public write access.

Re:date variable formatting 07 Mar 2008 18:15 #121

  • aellis
  • aellis's Avatar
In the current version of Logicity, there are not currently variables for the 2-digit month and day, but we will put this on our list to add. New variables to be added will be:

- Current Year
- Current Month Number (Leading Zero)
- Current Day Number (Leading Zero)

Our developers are currently on a 2 week lead time so I'd expect to see a new release with this functionality by the end of March. As a workaround until then, maybe you could manually pad the zero into the format.
The administrator has disabled public write access.

Re:date variable formatting 07 Mar 2008 20:38 #122

  • hcornell
  • hcornell's Avatar
I will do that, and also check back in a few weeks for the update.

Thank you for the quick reply!
Holly
The administrator has disabled public write access.

Re:date variable formatting 10 Mar 2008 04:01 #125

  • aellis
  • aellis's Avatar
Holly,

Just a heads up - we are uploading 1.5.0013 right now with the new variables mentioned above. Thanks for the feedback!

Take care,
Adam
The administrator has disabled public write access.

Re:date variable formatting 10 Mar 2008 20:17 #126

  • hcornell
  • hcornell's Avatar
That works beautifully! Thanks for your great product and service
The administrator has disabled public write access.

Re:date variable formatting 10 Mar 2008 20:17 #127

  • hcornell
  • hcornell's Avatar
That works beautifully! Thanks for your great product and service
The administrator has disabled public write access.

Re:date variable formatting 21 Apr 2008 09:44 #153

  • dwb@connexsoftware.com
  • dwb@connexsoftware.com's Avatar
I have recenlty downloaded version 1.6.3001.25776 which does not have the Current Year in the Insert Variable dialog for date parameters. However, if I type in %CURRENT_YEAR% that works.

Also, some other suggestions for date variables useful in parameters:

Last Year
Last Month Number
Last Month Last Day
Current Month Last Day

For leap year:
Last Year's Last Month Last Day
Current Year's Last Month Last Day

Alternatively, features similar to DateSerial would be VERY nice!
The administrator has disabled public write access.

Re:date variable formatting 21 Apr 2008 09:44 #154

  • dwb@connexsoftware.com
  • dwb@connexsoftware.com's Avatar
I have recenlty downloaded version 1.6.3001.25776 which does not have the Current Year in the Insert Variable dialog for date parameters. However, if I type in %CURRENT_YEAR% that works.

Also, some other suggestions for date variables useful in parameters:

Last Year
Last Month Number
Last Month Last Day
Current Month Last Day

For leap year:
Last Year's Last Month Last Day
Current Year's Last Month Last Day

Alternatively, features similar to DateSerial would be VERY nice!
The administrator has disabled public write access.

Re:date variable formatting 21 Apr 2008 09:45 #155

  • dwb@connexsoftware.com
  • dwb@connexsoftware.com's Avatar
I have recenlty downloaded version 1.6.3001.25776 which does not have the Current Year in the Insert Variable dialog for date parameters. However, if I type in %CURRENT_YEAR% that works.

Also, some other suggestions for date variables useful in parameters:

Last Year
Last Month Number
Last Month Last Day
Current Month Last Day

For leap year:
Last Year's Last Month Last Day
Current Year's Last Month Last Day

Alternatively, features similar to DateSerial would be VERY nice!
The administrator has disabled public write access.

Re:date variable formatting 22 Apr 2008 00:38 #156

  • aellis
  • aellis's Avatar
We've had a newer version of Logicity 1.6 in the download area, but forgot to activate it until you mentioned this. This was something that was fixed in the version that is up now, so can you try grabbing that one and see if that resolves your issue.

Thanks for the suggestions on new date variables. We'll add those to the list for addition into the next release.
The administrator has disabled public write access.
  • Page:
  • 1
  • 2