yesterday's timestamp for file names

tentree internal

• March 16, 2021 07:29

I'm exporting a daily sales report for daily sales (pulled at 1AM the following morning). Im trying to get the file name to have yesterdays datestamp in order to correspond with the day of the sales. 

Right now, i'm using DailySales_{{{timestamp "YYYY-MM-DD"}}}.csv --> but that's given me the day the report was pulled not the sales dates.

thanks

0

• 

  Kate Larson Senior UX Researcher Community moderator

  • March 16, 2021 16:11
  • Edited

  Hello tentree internal,
  Thanks for posting your question.

  Are you exporting this report from NetSuite?  Also, have you seen these sections in the Handlebars helper reference:

  • Timestamp
  • DataAdd

  0
• 

  tentree internal

  • March 16, 2021 19:30

  

  Hi Kate Larson 

  I used the handlebar helper reference to get the datestamp - which helped get me this far, but I can't seem to figure out how to get the date stamp to subtract a day. I'm thinking I have to utilize something to do with the dateoffset “-86400000”. I'm new to coding so all of this is foreign language.

  you are correct, it is a .csv export from Netsuite and transferring it to an FTP server where i want the filename to have yesterdays date stamped. 

  this mornings file which houses all of yesterdays sales is

  DailySales_{{{timestamp "YYYY-MM-DD"}}}.csv  --> DailySales_2021-03-16

  I'm trying to get it to read DailySales_2021-03-15

  any help would be greatly appreciated.

   

  thanks

  0
• 

  Kate Larson Senior UX Researcher Community moderator

  • March 16, 2021 22:03

  Hi tentree internal,
  Since the date is in the sales records, have you considered pulling that value out of the data and using it for naming the file rather than doing the date math? If you register for an office hours session one of our solutions consultants can walk you through this.

  0

Please sign in to leave a comment.