Date Format Error

[Pinky0404]

Hi All,

I have a conditional column  called Date , where i try to grab the date  from the source file each time when the source file is generated. These days when i try to update my  PBI file with the  new date, it throws a Date format error for all the values including the new date. 

 Temporarily i have to change the format  from #date(2017,9,22) to 09/22/2017 for all the date values from the beginning in the  output field to  resolve this error. 

Can anyone help me with some good solution for this please?

Thanks,

Pinky.

[v-chuncz-msft · Accepted solution]

@Pinky0404,

You may remove the double quotes in The Advanced Editor.

then #date(2017, 9, 22)