How to fetch the date and time from a csv file name in NAV

vivek4121

Hi All,
Can anyone tell me how I can fetch the date and time from csv filename (through code) in NAV having below format

{CompanyCode}_{ddmmyyyy}_{hhmmss}.csv

Thanks in advance

RockWithNAV

Are you getting date and time as a a separate Column in CSV??

Maxx

Store in ISO format, using FORMAT(currentdatetime,0,9)
Example:
2018-16-12T14:39:41.234Z

vivek4121

No, its not a column in csv, its the file name of csv.

Maxx

Thus, replace ':' (illegal character for filename) with '_':
FileName := COMPANYNAME + CONVERTSTR(FORMAT(currentdatetime,0,9),':','_')