Dateformat

Hello,

It all depends on what your dataset looks like.

If you have an infotable you'll need to loop through it and format each row at a time.

If you are fetching the data from a database you could do the formatting in SQL instead so you don't waste resources looping.

If you only have one value, which is this "CompleteData.ldate", then your code should look like:

let yourCSVColumnName = dateFormat(CompleteData.ldate, "YYYYMMDD");

The dateFormat function takes two arguments, one is your date variable and the other is the date format you want.

However, as I do not know what type your date is in, you can try to do this first:

let datetime = parseDate("2023-02-05 16:26:07.00", "yyyy-MM-dd HH:mm:ss.SSS");

This will turn a string date into a datetime and you can then pass it into the dateFormat function:

result = dateFormat(datetime, "YYYYMMDD");​