@datetime

Gary Beardsley
Gary Beardsley Employee
Third Anniversary 10 Comments Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board
in Platform

Hi Board Platform Wizards - Wondering if anyone could help me with the following conundrum... The standard @Datetime substitution formula you can use on layout file name exports as 'YYYY-MM-DD-HH-MM-SS' - Does anyone know of a way I can amend the standard format and instead export as 'YYYYMMDDHHMM' ? A client has requested a file export have a datetime stamp but without the dashes essentially. Interested to know if there is a work around. Thanks in advance 

Answers

  • Sophie Jones
    Sophie Jones Employee
    25 Up Votes 10 Comments Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board

    Hi Gary

    Is it on premise or on cloud? On premise, a batch file could rename the file. On Cloud, I'd ask cloud support. The same way we can use %%bss%% as a variable (and I imagine it's an environment variable), could they set up one with the time format you need?

  • Kevin Bettenbrock
    Kevin Bettenbrock Employee
    Second Anniversary 10 Comments Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board

    Hi Gary!
    Could you use an algorithm within the layout to remove those dashes and get the format you are looking for?

    Of course, if the format ever changes for some reason, this would have to be known and the formula adjusted to fit the new format.

  • Anish Sharma
    Anish Sharma Employee
    Second Anniversary Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board Name Dropper

    I have an additional use case of @Datetime on premise where we use for export files as a suffix to the filename. If there is a way of changing the definition of the function, that would be a superb addition to Board!

  • Leone Scaburri
    Leone Scaburri Employee
    Fourth Anniversary 100 Comments 5 Answers 25 Likes

    @Datetime substitution formula is culture-sensitive, so it depends on the server's date&time configuration.

Categories