format issue after selection in date prompt

[kthakur]

Hi All,

i am getting one strange error in date prompt after selection. my date column format is "MMMM"-"YYYY" i.e January, 2017.

everything is fine but whenever i select the value after selection, selected value is shown as Mon Jan 01 2018 00:00:00 GMT+0530(India Standard Time).

Client is not liking this behaviour and asekd us to change the format after selection.

can you please help me in finding the solution? Please see the attached image for more details.

Thanks

Krishna

[v-chuncz-msft]

@kthakur,

It seems to work for me. You may also try FORMAT Function.