Sign in to follow this  
Followers 0
SolemnPaladin

Yesterday's Date

6 posts in this topic

Hi,

I am having a hard time figuring out how to find the previous day's .bak file name. SQL generates my .bak files in the following format: 444_db_20081004. I have looked through the Macro section of the help file, but i cannot find a way to get yesterdays date. The gist of what I am trying to do is as follows:

$prevBAK = "444_db_" & @year & @mon & @mday - 1 & @hour & "00"

If I can get yesterdays date. The rest is gravy :-)

Thanks for any help!!

Share this post


Link to post
Share on other sites



Hi SolemnPaladin,

1st Welcome to the AutoIt Forums! :idea:

Some of the following tips may not apply to you, but it may make your life a bit easier here on the forum in the future.

CODE
  • Did you know that we have an awesome search feature?

    You can find many answers to your current questions, just by typing in the right search patterns.

  • A suggestion is to use the Advanced Search mode:

  • Type your specific search term in quotes.
  • Click the forum you want to search in (the one most likely to have your information would generally be the Example Script forum and or the General Help and Support Forum).
  • Click on "Search titles only" radio button.
  • Click perform search.
The above will help you narrow down your searches and prevent you from unneccesarily posting a new thread.

[*]Also, you should try to read the Sticky posts that are at the top of each of the AutoIt Forums you enter such as:

[*]Keep in mind, the help file will be your best friend, however you may find some of the tutorials written by some of our elite forum members helpful.

[*]Forum Etiquette:

  • Making a new thread:

    • Use the Search feature first to see if your question has already been answered.
    • Look in the help file as well before even thinking of posting (When what you want could be obtained by simply reading the help file, you don't generally get a good response from your AutoIt community).
    • Titles are very important here. 1 word titles or titles like "help me", "write something for me", "I'm a noob" etc... aren't tolerated.
    • Make sure you are posting in the correct forum:

      • General Help and Support:

        • This forum is for AutoIt related support questions only. If you have a question related to another language, or nothing at all to do with AutoIt then you need to post in the chat forum, or in that languages perspective forum.
      • Example Script:

        • This forum is for AutoIt scripts/executables only.
        • Source code is preferred but not necessary, you do have the right to just post the binary of your project if you wish.
        • Please don't post questions in this forum unless it's directly related to a thread already existing.
    • Use common sense when creating a new thread.

      Ask yourself if the title is descriptive enough to even interest someone (preferably those that know what they are talking about) to even look at your thread, let alone reply in it.

    • Think about how it would show in the search feature if someone were to look for something just like you are looking for (think of the keywords you used yourself and obviously didn't find anything (because we know you used the search feature :P ) and use those types of keywords in your title as well).
  • Thread content:

    • Be descriptive with your query. (Make sure we actually know what you want to do).
    • Show you've made an effort in coding what you want (provide the reproducer code (generally no more than 50 lines as people lose interest in debugging someones script for free)).
    • Don't talk in ebonics. A lot of the forum members are adults, and a lot of them know how to help you, but talk like a child, you'll be treated as such.
    • Don't ask for help making keyloggers, spam (even if it's to do as a prank), or anything that can be thought of as malicious. You'll more than likely have the thread locked by a moderator, and take a bashing from your fellow AutoIt community.
    • When posting code, use code boxes. This can be accomplished by using [code ]<content here>[/code ] (No spaces between the brackets []).

      Using code boxes will keep the indentation and make it easier to read for others to help you.

  • Bumping your threads:

    • Use common courtesy here.

      Keep in mind every time you bump your thread to the top of the forum, you knock the other threads down a notch.

      Everyone posting for help has just as much right for their threads to get read as you do.

      Because of that, do not bump your post more than once in a 24 hour period.

      A Bump is simply posting in your thread with nothing that pertains to your query with the sole purpose of moving it up.

      Deleting previous bumps, and posting new ones is not tolerated, and the moderators can find those deletions, so do yourself a favor and don't cross that line :( .

  • Rude or obnoxious content:

    This falls pretty much under the common sense thing. If you use it (common sense) before posting, you won't have issues.

    • Don't use foul language, remember, a lot of the community is at work when they read these threads.
    • Don't provoke or instigate an argument with someone.
  • Double Posting:

    • It's understood that sometimes there's a lag in the system, and sometimes people don't see their post go up right aways so they post again.

      If this happens to you, simply notify a moderator with the report feature in the post, and politely ask them to delete it.

    • If you're just creating another topic because your original topic is not being answered the way you want or at all, this is not tolerated. You could lose your posting privileges all together over it.
  • Non-English languages

    • If English is not your primary language, please make an attempt to interpret (yourself or online) and post that interpretation.

      We have wonderful users from around the world, so after you've done your post in English, back it up with your question also in your native tongue (You may find your answer much quicker using both).

That's it for now, I hope you have a wonderful learning experience, and hope to see you contribute to the community as your knowledge grows.

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

Hi!

Welcome to the forums.

Check out the Date functions in the help file, it allows you too easily add and subtract dates :P

Edited by monoceres

Broken link? PM me and I'll send you the file!

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

Seems your problem is within the Integer structure. Seeing as the Day format is "04" when converted into an integer (which is what happens when you subtract from it) it takes off the first 0 as it is not a proper integer format. So do somthing like:

If @mDay < 10 Then
    $Day=  "0" & @MDAY -1
EndIf
$prevBAK = "444_db_" & @year & @mon & $Day & @hour & "00"

Hope this helps

Edited by Marlo

Click here for the best AutoIt help possible.Currently Working on: Autoit RAT

Share this post


Link to post
Share on other sites

Hi,

I am having a hard time figuring out how to find the previous day's .bak file name. SQL generates my .bak files in the following format: 444_db_20081004. I have looked through the Macro section of the help file, but i cannot find a way to get yesterdays date. The gist of what I am trying to do is as follows:

$prevBAK = "444_db_" & @year & @mon & @mday - 1 & @hour & "00"

If I can get yesterdays date. The rest is gravy :-)

Thanks for any help!!

I wrote this a while back. May help in the future:

#Include <Date.au3>

MsgBox(0, "",   _DateSubtract(-1))


Func _DateSubtract($iSubtract)

    Local $Days[7] = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday" ]
    Local $Month[12] = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"]

    $Split = StringSplit(_DateAdd('d', $iSubtract, _NowCalcDate()), "/")
    $CurentDate = $Days[_DateToDayOfWeekISO($Split[1], $Split[2], $Split[3])] & ", " & $Month[$Split[2] - 1] & " " & $Split[3] & ", " & $Split[1]

    Return $CurentDate
EndFuncoÝ÷ Ø l¢Ø^~éܶ*'2èqêÞ³¬µ©dxn­¬)¶¬jëh×6#Include <Date.au3>


$Split = StringSplit(_DateAdd('d', -1, _NowCalcDate()), "/")
$PrevBKDate = "444_db_" & $Split[1] & $Split[2] & $Split[3] 


MsgBox(0, "", $PrevBKDate)

Share this post


Link to post
Share on other sites

Thanks for the warm welcome! I appreciate all of the responses! I perused through the Date functions like you guys suggest and it sparked an idea. I used the Julian Values instead to find the backup file that was created yesterday. Below is the search portion of my script

; get the julian date of today and yesterday

$jtoday = _DateToDayValue(@year,@mon,@mday)

$jyesterday = $jtoday - 1

; Finds the first SQL Backup file (.bak) in the current directory and stores it in $search.

$search = FileFindFirstFile("D:\MSSQL\Backup\444\*.BAK")

; Check if the search was successful

If $search = -1 Then

MsgBox(0, "Transfer 444", "Error: No SQL Backupfiles (.BAK) Found!")

Exit

EndIf

do

$file = FileFindNextFile($search)

If @error Then ExitLoop

; get the backup file's date and convert it to julian

$cFileCreatedDate = FileGetTime($file, 1)

$cjFileCreatedDate = _DateToDayValue($cFileCreatedDate[0],$cFileCreatedDate[1],$cFileCreatedDate[2])

until $cjFileCreatedDate = $jyesterday

FileClose($search)

The script works great now! Again thanks for the help! :-)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0