Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago
Solved

Get Date As Text

Hi all,   How can I get Date from DateTime field as Text in format "YYYYMMDD"? I tried Date.ToText([mydate],[Format = "YYYYMMDD"]) Buget getting error:   Parameter Error: We couldn't convert th...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Try this:

     

    Date.ToText(Date.From([mydate]),[Format = "YYYYMMDD"])

     

    --Nate

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago

Thanks Nate,

 

I have a datetime field

Im trying to convert the date to test in the format YYYYMMDD and the time to text in the format HHMMSS or something similar

My end game it to concatenate to an id to create a unique key since the id can have several rows as a workflow executes.

Thanks,

-w