-
1. Re: Control-M Variables
Good afternoon!
Here are some examples I use (Day/ Month/Year in Brazil)
12/20/2018 = %%DAY./%%MONTH./%%$DATE
20181220 (now) = %%$DATE
20181219 (Yesterday) = %%$CALCDATE %%$DATE -1
20181130 (last month) = %%$CALCDATE %%$DATE - %%DAY
Atte.,
Jonas Mota Junior
Cpd - Producao
www.riachuelo.com.br<https://www.riachuelo.com.br/>
<https://www.facebook.com/Lojas.Riachuelo> <http://www.riachuelo.com.br/> <http://statigr.am/lojasriachuelo> <https://twitter.com/riachuelo> <http://www.youtube.com/lojasriachuelo>
De: Eric Bryant
Enviada em: quinta-feira, 20 de dezembro de 2018 14:43
Para: Jonas Mota Junior Jonasm <jonasm@riachuelo.com.br>
Assunto: Suspeita de SPAM - - Control-M Variables
Control-M Variables
criado por Eric Bryant<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunities.bmc.com%2Fpeople%2Febryant373%3Fet%3Dwatches.email.thread&data=02%7C01%7Cjonasm%40riachuelo.com.br%7C2aa4796b68104819d54a08d6669a2ec7%7Cb832961306804673a03f9a18a0b0e93b%7C1%7C0%7C636809209762578006&sdata=7ya5jRUrEUtOJXTPuWM%2FYKAQJGgn8s0f4LMcB9DSagM%3D&reserved=0> em Control-M - Visualize a discussão completa<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunities.bmc.com%2Fmessage%2F800875%3Fet%3Dwatches.email.thread%23800875&data=02%7C01%7Cjonasm%40riachuelo.com.br%7C2aa4796b68104819d54a08d6669a2ec7%7Cb832961306804673a03f9a18a0b0e93b%7C1%7C0%7C636809209762578006&sdata=xJH4xva0OkQONrnrH2QMwqRld%2FYrLpLyiTheo6Kmn7E%3D&reserved=0>
1 of 1 people found this helpful -
-
2. Re: Control-M Variables
Thanks for the quick response.
So for me to get 12/09/2018, it will have to look like this:
%%$CALCDATE %%$DATE -11
Eric Bryant
Data Center Operations Supervisor | Information Technology
515-446-6470
CASEY’S GENERAL STORES
1 SE Convenience Blvd | Ankeny, IA | 50021
www.caseys.com<https://www.caseys.com/>
-
-
3. Re: Control-M Variables
I was able to echo %%$CALCDATE %%$DATE -11 and got 20181209 but need it in MMDDYYYY format.
Thanks,
-
4. Re: Control-M Variables
You can assemble the variable: 12/20/2018 = %%MONTH./%%DAY./%%$YEAR
12202018 = %%MONTH.%%DAY.%%$YEAR
Your example
Jonas Mota Junior
Cpd - Producao
www.riachuelo.com.br<https://www.riachuelo.com.br/>
<https://www.facebook.com/Lojas.Riachuelo> <http://www.riachuelo.com.br/> <http://statigr.am/lojasriachuelo> <https://twitter.com/riachuelo> <http://www.youtube.com/lojasriachuelo>
De: Eric Bryant
Enviada em: quinta-feira, 20 de dezembro de 2018 15:22
Para: Jonas Mota Junior Jonasm <jonasm@riachuelo.com.br>
Assunto: Suspeita de SPAM - Re: - Control-M Variables
Control-M Variables
resposta de Eric Bryant<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunities.bmc.com%2Fpeople%2Febryant373%3Fet%3Dwatches.email.thread&data=02%7C01%7Cjonasm%40riachuelo.com.br%7Cc811cb2735b1481df5a208d6669f9e99%7Cb832961306804673a03f9a18a0b0e93b%7C1%7C0%7C636809233119666223&sdata=Eu1Ai5BYlY5xX7hIWE%2BkNz5s2Wojz9GPUsMmEdn6AmY%3D&reserved=0> em Control-M - Visualize a discussão completa<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunities.bmc.com%2Fmessage%2F800880%3Fet%3Dwatches.email.thread%23800880&data=02%7C01%7Cjonasm%40riachuelo.com.br%7Cc811cb2735b1481df5a208d6669f9e99%7Cb832961306804673a03f9a18a0b0e93b%7C1%7C0%7C636809233119676235&sdata=jwhhhWEWez6u2IQsdpIxmAB1Y7JLvL%2FGdnRcV2EZdOo%3D&reserved=0>
1 of 1 people found this helpful -
-
5. Re: Control-M Variables
In text format:
DATA %%$CALCDATE %%$DATE -11
DIA %%SUBSTR %%DATA 5 2
MÊS %%SUBSTR %%DATA 7 2
ANO %%SUBSTR %%DATA 1 4
MMDDYYYY %%MES.%%DIA.%%ANO
Jonas Mota Junior
Cpd - Producao
www.riachuelo.com.br<https://www.riachuelo.com.br/>
<https://www.facebook.com/Lojas.Riachuelo> <http://www.riachuelo.com.br/> <http://statigr.am/lojasriachuelo> <https://twitter.com/riachuelo> <http://www.youtube.com/lojasriachuelo>
De: Eric Bryant
Enviada em: quinta-feira, 20 de dezembro de 2018 14:59
Para: Jonas Mota Junior Jonasm <jonasm@riachuelo.com.br>
Assunto: Suspeita de SPAM - Re: - Control-M Variables
Control-M Variables
resposta de Eric Bryant<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunities.bmc.com%2Fpeople%2Febryant373%3Fet%3Dwatches.email.thread&data=02%7C01%7Cjonasm%40riachuelo.com.br%7Cc3b793d635184e6e78b008d6669c6a9f%7Cb832961306804673a03f9a18a0b0e93b%7C1%7C0%7C636809219341793760&sdata=eTerANr4LE5PO%2BKf%2BXw9v2muXP0fONiegCGjzWFsl7k%3D&reserved=0> em Control-M - Visualize a discussão completa<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunities.bmc.com%2Fmessage%2F800878%3Fet%3Dwatches.email.thread%23800878&data=02%7C01%7Cjonasm%40riachuelo.com.br%7Cc3b793d635184e6e78b008d6669c6a9f%7Cb832961306804673a03f9a18a0b0e93b%7C1%7C0%7C636809219341803773&sdata=hPIR09FLt6ANenapzoXOaiEkpCSWglI%2Flp7IR0xjpZU%3D&reserved=0>
3 of 3 people found this helpful -
-
6. Re: Control-M Variables
Thanks for all your help, I was able to get exactly what I needed.
Eric Bryant
Data Center Operations Supervisor | Information Technology
515-446-6470
CASEY’S GENERAL STORES
1 SE Convenience Blvd | Ankeny, IA | 50021
www.caseys.com<https://www.caseys.com/>
-
