Changing Date Format in TDL

This is just the extract of the TDL. Full TDL is uploaded in attachment.

[System: Formula]
DestPath : ##DestinationPath + "\" + @@DateForm + "\" + @@TimeForm
CoNumber : $$String$CompanyNumber:Company:##SVCurrentCompany):5
DateForm : $$String:$$MachineDate
TimeForm : @@HrsForm + @@MtsForm
HrsForm : If $$StringPart:$$MachineTime:0:2 CONTAINS ":" +
Then $$StringPart:$$MachineTime:0:1 +
Else $$StringPart:$$MachineTime:0:2
MtsForm : if $$StringPart:$$MachineTime:0:2 CONTAINS ":" +
Then $$StringPart:$$MachineTime:2:2 +
Else $$StringPart:$$MachineTime:3:2


In this Auto backup TDL, i want to change the date format to YYYY-MMM-DD(2019-Feb-18). Currently the date format is DD-MMM-YYYY(i.e 18-Feb-2019).

Thanks in advance.

 

Which part in the code should be replaced by your code? I'm new to TDL so if you could help, i'd really appreciate.

 

This doesn't seem to work. At the time of creating backup following error shows "Function Backup Function LABEL: Action execution failed!"

 

Uploaded Error Screenshot

 

Still same error code is shown. I'm also uploading the updated tdl file for your reference.

 

Here is the error screenshot

 

Well...ok....thanks for your effort

 

Dear sahil,
This is 4 ur ref.
You can change the Date Format using Format attribute at the Field Level. Formats can be Universal Date, Short Date, Long Date, Month Ending, Separator.
● Format Universal Date renders date as D-MMM-YYYY i.e., 1-Apr-2010, 11-May-2010, etc.
● Format Short Date renders date as D-M-YYYY i.e., 1-4-2010, 11-12-2010, etc.
● Format Long Date renders date as Week, D MMM, YYYY i.e., Friday, 31 Dec 2010.
● Format Month Ending renders date as MMM YYYY i.e., Dec 2010.
● Format Short Date, Separator renders short date with desired separator as D Sep M Sep YYYY i.e., Short Date, Separator:"/" is rendered as 30/4/2010
For Example :

● [#Field: Plain VCH Date
● Format : Short Date, Separator:"/"
Regards

 

I tried this but didn't get it to work. Can you update the above uploaded TDL to make it work like this.

Thanks in advance

 

I think U have taken default date format with system formula that why @@ is use instead make date fiekd and in that Use: Universal Date Field. that will work

 

have u copied TDL from else where or is it urs?

 

Try 2 change ( DateForm : $$String:$$YYYYMMDDDateFormat:$$MachineDate:"-") 2 DateForm : $$String:$$D-MMM-YYYYDateFormat:$$MachineDate:"-" OR DMMMYYYY

 

I had copied it from somewhere, then I tried to modify it and learning TDL's side by side. Then I got stuck in the date field and came to know about this forum.

The current file you are looking at is modified according to my need.

 

Tried both, no success. Both show the same error as already uploaded above.

Also even if they did work, the output format would be DMMMYYYY which won't be of any use to me. I need YYYYMMDD.

 

Didn't work.....but it gave a weird error which was not like the one received above. Here is the screenshot.

 

Wow......it actually worked. Thank you so much for the effort.

Could you help me explain a bit about how this worked? The way i understood is that you defined a variable in DateForm and then used formula in that variable itself.
But when we were trying to do the same thing without the use of variable, it didn't working.