Convert date format to weekday

Hi All,

I was trying to convert the date type date to weekday and have used the following formula for that attached file-

DateTimeformat(DateTimeParse([Date of Ticket Purchase],'%m/%d/%Y'),'%A')

But it results out to few null output. Can anyone please help here. I have also attached the output received.

Thanks,

Archit Gharat

Accepted answers

Your date is in a different format, dd/mm/yy.

So you need to use DateTimeformat(DateTimeParse([Date of Ticket Purchase],'%d/%m/%Y'),'%A')

Best,

Fernando Vizcaino

Your date is in a different format, dd/mm/yy.

So you need to use DateTimeformat(DateTimeParse([Date of Ticket Purchase],'%d/%m/%Y'),'%A')

Best,

Fernando Vizcaino

Thanks a lot.

Hello,

Which format should we use if we also have seconds?

Would that be:

DateTimeformat(DateTimeParse([Date of Ticket Purchase],'%d/%m/%Y'%S),'%A')

Thanks!!!

Pat